LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
J_Barn
 
Posts: n/a
Default sumif - multiple conditions

I need to sum values by month/year (Ex: Jan 2006) based on data that I've set
up in an Excel spreadsheet.

My spreadsheet is set up in this fashion.
StartMonth : StartYear: Month1 : Month2 : Month3 : ...Month24
12 : 2005: 400 : 250 : 1000 : etc
1 : 2006 : 300 : 650 : 2500 : etc

Based on the Start Month and Start Year values, I want to sum the
appropriate figures into a Grand total for that particular month.

In this instance, Jan 2006 should = 550, Feb 2006=1650, Mar 2006=2500

Does anyone have a solution to this? I'm in desperate need of some help.
Thank you.


 
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
Conditional Sum and multiple conditions across different sheets Michael Dreher Excel Worksheet Functions 1 May 26th 05 05:25 PM
SUMIF with two conditions Fred Holmes Excel Discussion (Misc queries) 3 May 1st 05 10:10 PM
SUM based on multiple conditions - SORRY, URGENT!!! marika1981 Excel Worksheet Functions 4 February 18th 05 11:13 AM
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind Excel Worksheet Functions 1 January 28th 05 07:07 PM
Sum(if ... multiple conditions ... Interpretation? Ken Excel Discussion (Misc queries) 6 December 16th 04 10:23 PM


All times are GMT +1. The time now is 07:39 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"