[SOLVED] Need calculation based on 2 conditions

Hi -

I'm stumped. I am working on an expense report (similiar to a check book register) where Column A lists the months of the year and Column C lists a description, for example supplies. I'm trying to create a formula that reads a specific month of the year in Column A, for example January, then reads Column C looking for "supplies" to then return a calcuation subtracting columns E from Column F.

Thanks,

Kristen

With your data in a, c, e and f and in rows 1 thru 12, you could use this formula:

=SUMPRODUCT(($A$1:$A$12="January")*($C$1:$C$12="supplies")*($E$1:$E$12-$F$1:$F$12))

Adjust for your ranges.

The above formula will subtract as Column E - Column F. If you want it the other way around, change the last part to:
($F$1:$F$12-$E$1:$E$12)

- Moo

Glad to help.

- Moo