I tried it and now I get a #VALUE! error.
Let's complicate the issue a little more....

The description in either column can include part of the word or all (AMEX
or AM).
Also, I have two $ amount columns; one for debits, one for credits...

Help?
--
-A


"Shane Devenshire" wrote:

Hi,

Here is one way

=SUMPRODUCT((A1:A6=1)*(B1:C6="MC")*D16)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"alarson01" wrote:

I simply can't figure this out...

I have multiple locations that I need to find specific criteria and sum:

A B C
D
LOCATION DESCRIPTION1 DESCRIPTION2 AMOUNT
------------- ----------------- ----------------- ------------
1 MC blank
$50
1 PURCHASE MC $20
1 AMEX blank
$10
5 AMEX blank $25
7 PURCHASE VISA $75
7 VISA blank
$100

For example:
I want to find to total $ for location 1 with description of MC in either
column B or C. So this example would total $70.
Help?
Thank you!!!
--
-A