SumProduct (I think!) question

  • Thread starter Thread starter Emma C
  • Start date Start date
E

Emma C

Hi

Can anyone help with a probably simple query

I have 3 columns of data (example below) and I need to do a sum of cost if
the value in column A equals Saving and column B DOES NOT EQUAL Blue:

e.g:

Column A Column B Amount
-------------------------------------------------------------------
Saving Red £25.00
Saving Blue £10.00
Saving Green £10.00
Cost Red £10.00
Cost Green £10.00
Saving Yellow £10.00

So the answer in this case would be £45.00 but I have no idea how to do the
formula to include the "does not equal" part.

All help gratefully received!

Emma
 
I don't normally plug a site but Bob who maintains that site has added an
option to buy him a beer. There is more than enough content there to warrant
a beer. It is your call but I know that I bought him one.

Bob - I paid for the beer. Use the next donation to pay for the taxi...
 
Back
Top