Posted to microsoft.public.excel.worksheet.functions

Lok Tak Cheong Lok Tak Cheong is offline

external usenet poster

Posts: 14

SUMIF and INDIRECT

I have several working worksheets with data.

I made an summary sheet for all working worksheets.

The formula I used is =SUMIF(Sheet1!$C$3:$F$258,$A3,Sheet1!$F$3:$F$258)

Now, I attempt to replace "Sheet1" with function INDIRECT.

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	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
Indirect and Sumif Syntax Problems	[email protected]	Excel Discussion (Misc queries)	3	August 4th 06 01:59 AM
SUMIF INDIRECT	Alectrical	Excel Worksheet Functions	8	November 28th 05 02:05 PM
Combine Indirect and Sumif	dcd123	Excel Worksheet Functions	3	October 27th 05 04:20 PM

All times are GMT +1. The time now is 01:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us