Deadline countdown

If I understand correctly this could be accomplished by using a drop down with the source being the names of the sheets, lets say in cell A1. The formula could then be modified to read: =IF(C8=TRUE; D8*INDIRECT(A1&"!B2");0)
Let us know if you have any questions.

I am confused as to how this implements on a spreadsheet.
I believe that it would help if you could manually produce a spreadsheet that demonstrates what you are trying to accomplish. We may then be able to write formulas/code to automate the process.
To upload a sample spreadsheet (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

In the attached copy of the file the following additions/changes have been made:
1. D2:D5 are populated with the tab names that (I think) correspond to the stores in B2:B5
2. F5:G5 are populated using: =INDEX($D2:$D5,MATCH(TRUE,$C2:$C5,0))
Note that you could hide the values in D2:G5 by selecting the range and changing the font color to white.
3. F8 and down are populated using: =IF($C8=TRUE, $D8*INDIRECT(F$5&"!B"&ROW(A2)),0)
4. G8 and down are populated using: =IF($C8=TRUE, $D8*INDIRECT(G$5&"!C"&ROW(A2)),0)
Note that this proposal assumes that only one store will be selected.
Functions converted to English when I opened the file and should convert to Swedish when you open the copy attached to this post (also commas should convert to semi colons).
Let us know if you have any questions.

It may be possible to do what you want using Power Pivot, however that would mean a significant change to the appearance of the Budget sheet.
I wanted to check and see if that is acceptable before investing the time into attempting.
Let us know if you have any questions.

I played with the file a bit to see what Power Pivot might be able to do.
If it is useful, we can pursue it further and if not, that is fine too.
Let us know if you have any questions.

Administrative note

Seems that no VBA solution is required - Moved to Formula forum

Hello,
Thanks for the help!
I really dont want to lose the appearance, i thought i could solve it by an "if function" or some VBA?
is it not possible at all?

The idea is if i check (store 1 and store 2) i get an avrage of "min-price and the max-price" of store 1 and store 2 of everyting i choose to include in my shopping basket. se attached pdf for a example.

Thanks in advance!
Example template.pdf
Kind regards// ALN

Perhaps this will help:
1. Add a column to the tables on each of the PLIST sheets populated using: =AND(BUDGET!C$2,BUDGET!C8)
2. Get sheet Min. and Max. averages in cells F2:G2
2a. For F2: =IFERROR(AVERAGEIFS(PList1Table[MIN PRICE],PList1Table[Chosen],TRUE),0)
2b. For G2: =IFERROR(AVERAGEIFS(PList1Table[MAX PRICE],PList1Table[Chosen],TRUE),0)
3. On the sheet the individual PLIST Min and Max averages are populated using: =IF(INDIRECT(D2&"!F2")=0,"",INDIRECT(D2&"!F2")) and =IF(INDIRECT(D2&"!G2")=0,"",INDIRECT(D2&"!G2"))
4. The overall Min and Max averages are populated using: =AVERAGE(F2:F5)
Let us know if you have any questions.

Hello JeteMc,
Thank you for the reply, is it possible to get an avrage seperatly for each posts to sum it up below (se pdf).Attachment 667997
Or even in Min and max field insted of the actual cost?

Selecting Attachment 667997 (post #14) results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator"
It would be better to attach an .xlsx file anyway, as it is not possible to test formulas/code in a .pdf
Please manually include the output that you would like to have automated by formulas/code so that we will know what the formulas/code should yield.
Let us know if you have any questions.