Calculate Monthly Inventory Usage

[Brian]

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

 

[Don Guillett]

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

 

[Brian]

Thanks Don, but this returns the same result and does not ignore the quantity
that was received.

 

[Don Guillett]

If desired, send your wb to my address below along with specific
instructions and before/after examples.

 

[Don Guillett]

SUMPRODUCT((YEAR($A$2:$A$1000)=$V15)*(MONTH($A$2:$A$1000)=COLUMN(A7))*(TRIM($C$2:$C$1000)<>$Q$13)*$D$2:$D$1000)

 

[Brian]

The formula worked fine for what I asked, but I found there were some other
issues that causes problems for what I needed. The formula mutated to...

=SUMPRODUCT((YEAR('2928'!$A$2:$A$1000)=$B$2)*(MONTH('2928'!$A$2:$A$1000)=COLUMN(A7))*(LEFT('2928'!$C$2:$C$1000,9)=$U$2)*'2928'!$D$2:$D$1000)

The part of the formula above with ($U$2) needs to include both ($U$2) &
($U$3). If the range ('2928'!$A$2:$A$1000) equals either of the the cells
($U$2) or ($U$3), it will include the qty in the calculation.

Any takers for this problem?

Brian