LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rb
 
Posts: n/a
Default 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing values if conditions are true mike camburn Excel Worksheet Functions 2 December 12th 05 09:38 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Summing values within a range rmellison Excel Discussion (Misc queries) 7 September 2nd 05 12:43 PM
Add cells from a range based on 2 conditions from 2 other ranges Kelly Excel Worksheet Functions 3 July 7th 05 07:40 PM
Add a Dynamic Range with 2 Conditions Q John Excel Worksheet Functions 7 December 23rd 04 02:58 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"