Excel sum formula

[gnana]

Hi

I had attached a excel file where i need to sum the value and copy the formula to other part of the sheet and paste.

1. I have 3 tabs in my file. OFC, CFC & OBOA.
2. In OBOA tab (C7) i referred the value from "OFC!AE10". (both highlighted in Yellow)
3. I copy and paste the formula from C7 to C29. but i am getting the result "0", because it will refer OFC!AE32. But i need the value "OFC!AE20" in place of it.

Because i need to do it for all 30 days of the month. Please help me to resolve this issue.

thanks,
~gnana

[vlady]

why not just edit it i think you only have 3 of that formula

actually can also attain that also by

copy -- paste special -- paste link

go to tab "OFC!AE20" clcik copy

then go to OBOA choose paste special - then link

[gnana]

Hi Vlady,

Thank you for your response.

For sample purpose i have provided only 3 tables. Actually it needs to be done for entire month as done in "OFC" sheet.

Thanks.
~gnana

[NBVC]

Try this in C7:

=INDEX(OFC!AE:AE,COUNTIF(C$4:C6,"Sales")*10)

Then copy that and paste to other cells....

[gnana]

Thank you very much NBVC - It solved my problem.

Thank you.
~gnana