Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Formula help

Because ranges are not of same size!
S4:X99 should be S4:S99 or V4:X99

Regards,
Stefi

€˛ISAF Media Analysis€¯ ezt Ć*rta:

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

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