Posted to microsoft.public.excel.worksheet.functions

JHL

external usenet poster

Posts: 56

Help with Sumif and INDIRECT

Hello,
Im using the formula below to sum multiple sheets that has a code in cell
D1. I would like to modify if possible to accommodate one more criteria in
cell F1 of the summary sheet. The references for E:E and B:B should remain
the same.

I obtained this formula awhile back using this forum.

Thank you.

=SUMIF(INDIRECT("'"&A2&"'!E:E"),summary!$D$1,INDIR ECT("'"&A2&"'!B:B"))

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 & INDIRECT problems	LongTermNoob	Excel Worksheet Functions	8	January 3rd 08 09:22 PM
SUMIF and INDIRECT	Lok Tak Cheong	Excel Worksheet Functions	3	April 10th 07 06:26 AM
sumif + indirect	kevcar40	Excel Discussion (Misc queries)	3	March 13th 07 03:24 PM
SUMIF + INDIRECT?	Davoud	Excel Worksheet Functions	4	February 22nd 07 07:50 PM
SUMIF INDIRECT	Alectrical	Excel Worksheet Functions	8	November 28th 05 02:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us