I've attached an example, but I have two columns, one column has percentage numbers in it and the column next to it has either Yes or No. What I want to do at the bottom is to sum only the percentages that have a yes in the column next to it and then sum only the percentages in the column that have a no next to it. Any help would be much appreciated
Cheers!
Dan
you can sum those up - BUT is that exactly what you want to
anyway
=SUMIF(D4:D23,"yes",C4:C23)
=SUMIF(D4:D23,"no",C4:C23)
But that will give you over 100%
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Here you go. There are multiple ways to accomplish it, but I chose to use Pivot Tables which you may enjoy reading up on.
I'm fine with the over 100% numberIt works great thanks!
you are welcome, thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks