Summing and Counting based on 3 criteria

[Todd]

I am trying to sum and count based on 3 criteria from
another tab with no luck. Example
I want the sum of the criteria in column P in sheet2 if
column B="Phoenix", column E="1", and column j="807" and
return that to a cell in sheet1.

Same scenerio with the counting.

Any help would be very appreciated.

Thanks Todd

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--('sheet2'$B$1:$B$100="Phoenix"),--('sheet2'$E$1:$E$100=1)
,--('sheet2'$J$1:$j$100=807),'sheet2'$P$1:$P$100)

if your numeric values are stored as real numeric values.

 

[Guest]

Thanks Frank. I am receiving a #N/A, any thoughts?
Todd

 

[Frank Kabel]

Hi
do you have #NA errors in the checked ranges or in column P?

 

[Guest]

Yes I do. The formulas were copied down and I got a #N/A
on those lines. I changed the range. Thanks Frank. You are
a great help!

Todd