Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |