Summing and Counting based on 3 criteria

T

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
 
F

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.
 
G

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
 
Top