SUMIF Question

[Deb]

Can you do a range such as M4:O10? My spreadsheet let me put this in but it
is not giving me the correct value. I have a 1 in cell O4 and it is giving
me a value of "0" for this formula.
=SUMIF('June08 Summary'!$E$4:$E$10,"DM",'June08 Summary'!M4:O10)

 

[Peo Sjoblom]

No, sumif and countif will only sum/count M4:M10 in your case. If you want
to sum all entries in M4:O10 where E4:E10
regardless if there are multiple entries on the same row you can use


=SUMPRODUCT(('June08 Summary'!$E$4:$E$10="DM")*('June08 Summary'!M4:O10))

--


Regards,


Peo Sjoblom

 

[Max]

True that it's accepted as you posted, but it's just an illusion. SUMIF
doesn't work on multi-ranges. Only the figs in the leftmost col M will get
summed.

You could try using sumproduct though:
=SUMPRODUCT(('June08 Summary'!$E$4:$E$10="DM")*'June08 Summary'!M4:O10)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik