|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 10th, 2009, 01:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
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"))) 
|
|
#2
February 10th, 2009, 01:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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")))
|
|
#3
February 10th, 2009, 03:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
That should work ok.
What happens when you try it? If you get an error returned, then look for an error in one of those ranges. If the count is not what you expected, then maybe the values in the cells aren't what you think they are. Maybe they have extra spaces (leading, trailing or embedded) in the strings. ISAF Media Analysis wrote: 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"))) -- Dave Peterson
|
|
#4
February 10th, 2009, 04:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
For V4, read X4 ? :-)
-- David Biddulph "Stefi" wrote in message ... 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")))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
