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

"Deb" wrote in message
...
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)
--
Deb