Summing a range with conditions
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?
|