Updating a Formula Based on Multiple sheets
 

Dear All,

Please find the demo file.

I'm having a work book that consists of 31 pages for the days then
finally
a summary page.

On the summary page cell B16 there is a sumif function which is linked
to the first page.i just need to update the formulas to the balance
columns and rows,rather than changing it manually.Dragging and copy&
paste method will not work.

=SUMIF(INDIRECT(""&B$4+($B16:B16)&"'!E5:E10"),"Fre e",INDIRECT("'"&B$4+($B16:B16)&"'!D5:D10"))

This is the formula that I've given it there,but its not working or not
showing
any errors too.giving me a zero,where actually it should be 6

Please Advice

Thanks In Advance,
Aks


+-------------------------------------------------------------------+
|Filename: Demo2.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=120|
+-------------------------------------------------------------------+

--
aks1983
------------------------------------------------------------------------
aks1983's Profile: http://www.thecodecage.com/forumz/member.php?userid=283
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

Hi and welcome to the board,

it is not quite clear to me what you are trying to do.
Do you want to sum the values in D5:D10 where there is " Free" in the
range E5:E10 ?
This would not have anything to do with the word "apple" then?


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

Would this help ?


Code:
--------------------
=SUMIF(INDIRECT("'"&B$4&"'!E5:E9");"free";(INDIREC T("'"&B$4&"'!D5:D10")))
--------------------


( replace ; with , if needed)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

Thanks for your reply

yeah you are right,i dont have have anything to do with the apple.
i just need that sumif fuction to work properly.

Regards,
Aks


--
aks1983
------------------------------------------------------------------------
aks1983's Profile: http://www.thecodecage.com/forumz/member.php?userid=283
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

Have you checked the proposed formula?


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

aks1983;333410 Wrote:
Thanks for your reply

yeah you are right,i dont have have anything to do with the apple.
i just need that sumif fuction to work properly.

Regards,
Aks
--- Automerged consecutive post before response ---
thanks dear it works.

Thanks,
Aks
Glad we could be of help!


Pecoflyer;333414 Wrote:
Have you checked the proposed formula?The OP did and it worked for them, good work Pecoflyer!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Updating a Formula Based on Multiple sheets
 

Just one more doubt Pecoflyer

=INDIRECT("'"&C$6&"'!J"&5+(ROWS(C$9:C9)-1))-C33

where i need,when dragging across the rows j5 to be updated
automatically
now i think it is stable.

Eg:C:10 it should be =INDIRECT("'"&C$6&"'!J"&6"+(ROWS(C$9:C10)-1))-C34

Please Advice,

Regards,
Aks


--
aks1983
------------------------------------------------------------------------
aks1983's Profile: http://www.thecodecage.com/forumz/member.php?userid=283
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158