Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following info on one tab:
Date Acct Amt 1/31/2006 100200 1,000.00 1/31/2006 101000 -1,891,715.85 1/31/2006 103000 44,013.05 1/31/2006 103500 0 1/31/2006 105000 612,999.69 1/31/2006 110000 7,903,395.07 1/31/2006 115000 5,146,140.11 1/31/2006 115500 2,810.43 1/31/2006 116000 -11,389.91 On another sheet I'm trying to sum by acct by month in different columns. I have tried sumif and apparently that can only handle 1 criteria. I've tried sumproduct and can't get that to work either. Is there a way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing values if conditions are true | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Summing values within a range | Excel Discussion (Misc queries) | |||
Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions |