SumIfs
 

B C D
E
Payee Account Category Amount
A. Datum Corporation Cash Publications 18.80
Adventure Works 2877 Furnishings 58.94
Alpine Ski House Cash Publications 177.00

I have a list that is 925 rows in length and I would like to be able to add
all the payees amount details that are for cash. ie all Datum Corporation
who paid in cash. I tried =SUMIF(C2:C925,"A. Datum Corporation,Cash",E2:E925)
I got into a bit of a pickle!!
Any boffs out there with the knowledge would be greatfully received.
Regards. P

SumIfs
 

Try this:

=SUMPRODUCT(--(B2:B925="A. Datum Corporation"),--(C2:C925="Cash"),(E2:E925))

HTH,
Elkar


"timson" wrote:

B C D
E
Payee Account Category Amount
A. Datum Corporation Cash Publications 18.80
Adventure Works 2877 Furnishings 58.94
Alpine Ski House Cash Publications 177.00

I have a list that is 925 rows in length and I would like to be able to add
all the payees amount details that are for cash. ie all Datum Corporation
who paid in cash. I tried =SUMIF(C2:C925,"A. Datum Corporation,Cash",E2:E925)
I got into a bit of a pickle!!
Any boffs out there with the knowledge would be greatfully received.
Regards. P

SumIfs
 

I would use sumproduct
=sumproduct(--($b$2:$b$925="A.datum
corporation"),--($c$2:$c$925="Cash"),$e$2:$E$925)

"timson" wrote:

B C D
E
Payee Account Category Amount
A. Datum Corporation Cash Publications 18.80
Adventure Works 2877 Furnishings 58.94
Alpine Ski House Cash Publications 177.00

I have a list that is 925 rows in length and I would like to be able to add
all the payees amount details that are for cash. ie all Datum Corporation
who paid in cash. I tried =SUMIF(C2:C925,"A. Datum Corporation,Cash",E2:E925)
I got into a bit of a pickle!!
Any boffs out there with the knowledge would be greatfully received.
Regards. P

SumIfs
 

My grateful thanks.
P

"Elkar" wrote:

Try this:

=SUMPRODUCT(--(B2:B925="A. Datum Corporation"),--(C2:C925="Cash"),(E2:E925))

HTH,
Elkar


"timson" wrote:

B C D
E
Payee Account Category Amount
A. Datum Corporation Cash Publications 18.80
Adventure Works 2877 Furnishings 58.94
Alpine Ski House Cash Publications 177.00

I have a list that is 925 rows in length and I would like to be able to add
all the payees amount details that are for cash. ie all Datum Corporation
who paid in cash. I tried =SUMIF(C2:C925,"A. Datum Corporation,Cash",E2:E925)
I got into a bit of a pickle!!
Any boffs out there with the knowledge would be greatfully received.
Regards. P