try
=SUMproduct(($H$2:$H$100="1/2009")*($c$2:$c$100<"Received against
PO")*$D$2:$D$100)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brian" wrote in message
...
I'm trying to calculate monthly inventory usage from data retrieved from
daily usage reports. The formula below works, but not sure how to ignore
rows
with receiving data. Column "C" includes notes and I would like to ignore
in
my calculation all rows with the note of "Received against PO". How can
this
be accomplished?

The formula I'm currently using is...
=SUMIF($H$2:$H$100,"1/2009",$D$2:$D$100)

Column "H" has the month/year and column "D" includes both usage and
receipts.

Thanks in advance!

Brian