Posted to microsoft.public.excel.worksheet.functions

phuser[_2_] phuser[_2_] is offline

external usenet poster

Posts: 14

Specifing Cells to Sum on Condition

I have a spreasheet that contains data for 3 years

Jan 2006 Jan 2007 Jan 2008
50 50 0

Etc. Etc

All the months are populated for 2006 & 2007

But 2008 only has cells populate to June

I would like to sum only the rows for 2006 & 2007 up to the same YTD as 2008

The columns are there for 2008 there are just no numbers populated.

Is this possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Count cells with condition	Amanda	Excel Worksheet Functions	2	October 13th 07 06:59 PM
Sum of cells under a condition	Colin	Excel Worksheet Functions	4	August 24th 07 09:46 AM
specifing colors in an excel chart	keith	Charts and Charting in Excel	2	May 28th 06 05:02 AM
Hiding cells on condition	Pennington	Excel Worksheet Functions	19	April 21st 05 12:30 AM
sum of a cell if 2 cells meet a condition	Markitos	Excel Worksheet Functions	4	January 4th 05 05:27 PM

All times are GMT +1. The time now is 04:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us