Excel Formula

[techie99]

I need an Excel formula that adds up specific cells in column H that meet the following conditions. If the cell in column D = 100 or 800 AND if the cell in column G does not equal "CA", "FML", "FMU" or "ULW".

A B C D E F G H I J K
100 CA 2
100 OT 10
900 1R 14
800 FMU 17

So, in my example, the total of column H would be 10

So far I have
=SUMIF(D630,100,H6:H30) + SUMIF(D630,800,H6:H30)

This accomplishes the first objective to only count cells with criteria matching column D, but this doesn't take into effect the criteria for column G. Any idea how to do this? Thanks in advance for all your help.

 

[joeh17]

Could create an entry in Column I with the following formula:


=IF(AND(OR(D6=100,D6=800),G6<>"CA",G6<>"FML",G6<>"FMU",G6<>"ULW"),H6,0)

apply it to each row and SUM it at the end.

Not the neatest, but the first thought to pop into my head.

 

[CBasicAsslember]

See

http://www.tek-tips.com/viewthread.cfm?qid=1311636

for a similar problem.

 

[techie99]

Thanks for the suggestions, I'll give them a try.