Question Please!!!

[amyacc]

I've been trying to do a function, like a SUMIF, that says...

If it's rated F(Column O) and is for Easter (Column B) then sum matching $ amount (Column H).

Any thoughts?

Thanks.

-Amy

 

[Aladin Akyurek]

On 2002-05-08 13:30, amyacc wrote:
I've been trying to do a function, like a SUMIF, that says...

If it's rated F(Column O) and is for Easter (Column B) then sum matching $ amount (Column H).

Any thoughts?

Thanks.

-Amy

=SUMPRODUCT((O2:O100="F")*(B2:B100="Easter"),(H2:H100))

You can also put the conditions/criteria in cells of their own and use the cell refs in the formula instead.

Aladin