Posted to microsoft.public.excel.misc

external usenet poster

Posts: 661

Multiple Sumif conditions

I have a list of data by date of power production. What I want to know is
how much power was generated in December 2009, January 2010, etc. The data in
a sheet with the dates in column A and power production in column B. I have
another tab with the months in the rows and the years on the columns.

I am sure there is a way to do this with sumproduct, but i am not sure how to.

Thanks in advance.

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
SUMIF with multiple conditions	Tim	Excel Discussion (Misc queries)	5	September 15th 09 08:51 PM
Multiple Sumif conditions	Alcala	Excel Worksheet Functions	2	August 18th 08 05:30 PM
sumif with multiple conditions	myl	Excel Worksheet Functions	1	July 8th 08 09:35 PM
SumIF-multiple conditions/OR	GaryW	New Users to Excel	7	May 15th 08 04:16 PM
SUMIF with Multiple Conditions	TexJen09	Excel Worksheet Functions	5	March 17th 08 03:39 AM

All times are GMT +1. The time now is 12:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us