This is my first post on this site, hopefully my format is okay.
I'm stuck on this formula:
=IF(E2="Y","100%",D2/SUMIF($E$2:$E$5, "",$D$2:$D$5 ))
I'm trying to find the percentage of 2 values (D2/sum_range) but the sum_range ($D$2:$D$5) is dependant on two conditions.
1. The variable in Col A is the same as the value in A2.
2. The variable in Col C is the same as the value in C2.
I have attached an example of what I am trying to do that explains in further detail.
Thank you in advance.
Welcome to the forum. Try this formula in F2:
=IF(E2="Y",100%, D2/SUMIFS($D$2:$D$13, $A$2:$A$13,A2,$C$2:$C$13,C2,$E$2:$E$13,""))
That worked perfect! I forgot about the new SUMIFS function, thanks a million Colin!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks