Hi everyone-
I am hoping for some help. I have a column of data (AD) that I would like to add, but only if a number (rating) for the data in column C equals a certain value.
For example, if rows 5, 8, 15, and 30 have a rating of 1, rows 6, 7, 10 and 20 have a rating of 2, and rows 9, 11, 18 and 22 have a rating of 3, how do I add the data for all rows in column AD, but only for the rows that have the rating 1?
The goal is to be able to show the total of the data for all three ratings as a percentage of the overall total.
Please let me know if this explanation is confusing or imcomplete, I can try again!
Any help is greatly appreciated! Thanks so much!
Bookmarks