Formula help

  • Thread starter ISAF Media Analysis
  • Start date
I

ISAF Media Analysis

Can anyone help on this. I can't figure out why this formula does not work.

=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="neg")*(S4:X99="SE 11.1")))
 
S

Sean Timmons

because you are looking for a sum of values in the below case. To get a
count, use --.

so:

=SUMPRODUCT(--(E4:E99="Kabul")*--(H4:H99="neg")*--(S4:X99="SE 11.1"))

will get it. (also got rid of your extra set of paretheses.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing formulas 2
Formula problem 1
Leave final cell blank 2
Formula problem 3
Returning last number(time) in a row of cells 4
IF OR Formula 4
problem in Excell 2003 4
Average last 3 entries 3

Top