Counting values if name matches

[moley165]

Hi all,

basically below is the sum i have to count the value of 1 for each time a name shows up and matches the word in the " "s. now what i need it to do is every time in cells E2:E99=x3(name) and matches a2:a99= assistance then it will count the values in j2:j99, but ofcourse i only want it to count the money in cells j2:j99 if the other 2 criteria have been met.


=SUMPRODUCT(($E$2:$E$99=X3)*($A$2:$A$99="Assistance ") )


sorry if im being to messy or vague


kind regards


ricky

[martindwilson]

count or sum ?=SUMPRODUCT(($E$2:$E$99=X3)*($A$2:$A$99="Assistance "),j2:j29 ) will add up everything that meets the condition
you could try
for a count
=SUMPRODUCT(($E$2:$E$99=X3)*($A$2:$A$99="Assistance ")*(j2:j29<>"" ))

[Søren Larsen]

I'm not sure I follow completely, but maybe this:

Please Login or Register  to view this content.

If this is not what you need, perhaps you caould upload a sample of your workbook?

[moley165]

perfect thank you