Year End totals
Kevin@Radstock wrote:
Hi Pamela
I do not quite follow your formula!
But FYI SUMIF/SUMIFS will not work across sheets (well not on their own)
and nor will SUMIF/SUMIFS accept arrays, but there are a work arounds. I
am assuming you are using Excel 2007
First you need to to put a list of your sheets in say Z1:Z24, ensure you
spell the sheet names correctly, then define a name for the list, say
for example "Sheets".
If cells D4:D100 contain dates and you need to Sum for the year 2012.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheets&"'!E4:E100" ),INDIRECT("'"&Sheets&"'!D4:D100"),"=01/01/2012",INDIRECT("'"&Sheets&"'!D4:D100"),"<=31/12/2012"))
Sorry will have to post the other part seperately due to "Smilies"!!!!
Administrator/Moderator. If you read this, can you disable the "Smilies"
Thanks Kevin. I really appreciate your efforts. Will give it a try and
get back later in the week.
|