counting on two condtions

[JulieD]

Hi Kevin

one option
=SUMPRODUCT((D483=U$10)*(B4:B83=X$4)*E4:E83)

Cheers
JulieD

 

[kevin carter]

Hi

I have a worksheet with a range of data
the following formula returns the value of column E where the condition
P4 is matched in column B No problem with is

=SUM(IF((B4:B83=$P$4),E4:E83))

What i need to do is to check a second column along with the first column and
return the value of column E where both condtions are true
ie
=AND(SUM(IF((D483=U$10),(B4:B83=X$4,E4:E83))))

can anyone help please


thanks in advance

kevin

 

[Don Guillett]

try (NON array)
=sumproduct((d4:d83=u10)*(b4:b83=x4)*e4:e83)