Posted to microsoft.public.excel.worksheet.functions

TamIam

external usenet poster

Posts: 29

sumif nightmare!

I was wondering if it's possible to use sumif with multiple criteria? In a
pivot table I have periods in a column with their corresponding values by
month in each row. In the left most column of the pivot table I have sorted
by revenue & expenses. I need to sumif (column d:d,"revenue" and column
e:e,"LY 2007", values in column f:f)

Sorry for the confusion!
--
Thanks for your help!

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
PivotTable Nightmare	Sandi	Excel Discussion (Misc queries)	3	March 3rd 07 04:34 PM
Concatenate Nightmare!	DEE	Excel Worksheet Functions	10	November 16th 06 12:00 AM
PivotTable Nightmare	MarkM	Excel Discussion (Misc queries)	1	August 14th 06 07:41 PM
VLookup Nightmare!	twarden	Excel Worksheet Functions	3	July 24th 06 11:46 PM
IF Statement nightmare	eugenevr	Excel Discussion (Misc queries)	6	May 18th 05 01:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us