| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS() error? | Excel Worksheet Functions | |||
| Excel CountIfs() and SumIfs() question | Excel Worksheet Functions | |||
| [Excel 2007 Beta2] Function SUMIFS | Excel Worksheet Functions | |||
| Joining 2 SUMIF's ??? | Excel Discussion (Misc queries) | |||
Linear Mode
