use sumif with criteria including sheet name
First a big THANK YOU to Thomas[PBD] for your answering my question.
It is within only one workbook, not multiple files. I am aware that with
SUMIF we got to have <range, <Criteria,<Sum_Range. I believe the key
question here can be simply represented by:
SUMIF(BeginSheet:EndSheet!A1, "Sept", BeginSheet:EndSheet!B1)
error: #VALUE!
Can anybody explain why we got this error?
Thanks in advance for helping!
"Thomas [PBD]" wrote:
SleepyCat,
Are you attempting to Sum the "Sept" sheets in the same workbook, or across
multiple workbooks?
I noticed two things first off, SUMIF requires <range,
<Criteria,<Sum_Range. You are placing the Criteria in the Range section.
Therefore this is going to error out.
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.
"SleepyCat" wrote:
I have a workbook which will be added new worksheets to by others. The
worksheet names are all month names.
I want to do a sumif according to the name of the worksheets, i.e. according
to the month specified by the worksheet name.
I am using the following formula, and it doesn't work:
=SUMIF(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),
"=*Sept*", STATISTICS:BLANK!C1)
with an intention to sum up the C1's in all sheets with the sheet's name
including the string "Sept".
Could anybody please help me out with this, thanks a bunch in advance!
Theresa
|