Formulas Across Tabs & Percentages

[BryanParry]

Hi there, guys,

I've looked through several pages of promising-looking threads and I can't find the answers. I hope some of you guys can help me.

QUESTION 1
Basically, I've got a workbook. On one tab I've got all of my data. I want to create a summary table in a DIFFERENT tab, but use the data from Tab 1.

An example formula is: =SUM(F8/E8)*100
HOWEVER, these cells (F8 & E8) would actually be on Tab 1, a different tab.

Is there a formula for this? The reason I want to do this is that I want the breakdown on data, and then a separate summary. However, the summary and the breakdown on one page might look a little cluttered.

QUESTION 2
I can't seem to figure out how to get a percentage rounded to 2 sp. e.g. 76.45%, 50.00% etc. The way I am fudging it is as above: =SUM(X1/Y1)*100. However, this looks rather messy.


Hopefully you guys can help me out here.

Many thanks,

Bryan

 

[wsjackman]

Hi there, guys,

I've looked through several pages of promising-looking threads and I can't find the answers. I hope some of you guys can help me.

QUESTION 1
Basically, I've got a workbook. On one tab I've got all of my data. I want to create a summary table in a DIFFERENT tab, but use the data from Tab 1.

An example formula is: =SUM(F8/E8)*100
HOWEVER, these cells (F8 & E8) would actually be on Tab 1, a different tab.


QUESTION 2
I can't seem to figure out how to get a percentage rounded to 2 sp. e.g. 76.45%, 50.00% etc. The way I am fudging it is as above: =SUM(X1/Y1)*100. However, this looks rather messy.


Bryan

Q1
you do not need the sum
='Tab 1'!F8/'Tab 1'!E8

Q2
maybe just format the cell as percentage wth two decmals showng.

 

[Stuart Little]

Hi Bryan,

Is your data always static on the data worksheet?

If so, On the summary worksheet you could just type =sum(select the data worksheet and click cell f8/cell e8)

Regards,
Stu

 

[VoG]

Try

=ROUND((Sheet1!E8/Sheet1!F8)*100,2)

 

[Andrew Poulsom]

Example for Q1:

=Sheet1!F8/Sheet1!E8*100

Example for Q2:

=ROUND(X1/Y1,4)

formatted as percent with 2 decimal places.

Note that you don't need the SUM function in either formula because you aren't summing anything.

 

[BryanParry]

wsjackman, Stuart Little, VoG, Andrew Poulsom,

Many thanks. With your help, I've sorted this now.

Also, thank you very much for your extremely swift replies, and apologies for my rather slow recognition of that fact.

Cheers,

Bryan