Calculating a % across several cells in the same row.
Hi all,
I sure this is a very dumb question, however, I can't find anything on the forum about it. My formulae knowledge is a little basic so please bear with me.
I have a sheet which pulls in the totals of columns using a COUNTIFS statement (the content of the columns is from a drop-down list) The column can have 1 of 4 different values. I then populate 1 of 4 different columns with the total number of times that word appears in the source sheet. I then want to work out the percentage value from that 2 of the cells add up to as a percentage of the total across the four cells. I have included the formula that doesn't work, it seems logical it's just not spreadsheet parsable :-(
=SUM(([Non-Compliant]1, Compliant1, [Unable to Verify]1, [Not Applicable]1) / 100, *(Compliant1, [Not Applicable]1))
Thanks in advance.
Kind regards.. Ben.
Comments
-
think something with your brackets is not in the right place.
also not clear about the: 100, *
are you tryint to multiply the Sum / 100 result with the rest?
Try this:
=(SUM ([Non-Compliant]1, Compliant1, [Unable to Verify]1, [Not Applicable]1) / 100) * SUM(Compliant1, [Not Applicable]1)
-
Bang on. Thank you very much.
-
You are welcome.
Glad I could help.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives