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

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

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

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

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

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

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