Sum if Formula help

[tmo]

I think this will be an easy one for most of you...

I have a total of 5 columns with inventory tracking information. I want to write a sum if equation that allows me to add current stock amounts based on criteria contained in 2 other columns, but can't get the formula right. The criteria is based on what the other cells contain, not what they equal, e.g. if the cell's contents are "IH control stability", I want excel to include the cell because it contains "IH"

It's set up like this:
A B C D E
1 Qty Date Lot # Initials Comments

Cell formatting is #'s in Column A, data (formated as 1-Mar-09) in column B, numbers in column C, text in columns D and E.

I want to add all quantities in column A IF they were removed in March (entered in column B) and IF they contain "IH" in column E

Please help!

 

[barry houdini]

You can use SUMPRODUCT, something like this

=SUMPRODUCT(--(TEXT(B2:B100,"mmm-yy")="Mar-09"),--ISNUMBER(FIND("IH",E2:E100)),A2:A100)

 

[tmo]

Thank you so much - it worked beautifully!