I need to count one or the other cell as One

[beekerdale]

If anyone could help me with this formula I would be super grateful.. Thanks in advance.

This formula below works fine with the exception that I now require the formula to only count “one” if there is two inputs on each cell of the nine pairs (“W128 & W129” is what I call a pair for example)


Common sense would tell me to put a “or” between the W128&W129, N128&N129, G128&G129, AF117&AF118, Y117&Y118, P117&P118, I117&I118, AI106&AI107, AB106&AB107


I need each of these pairs to be seen as as a result of One of the “five”
So each pair should only count once, not twice like they currently do.

Here is my current formula:
=IF(COUNT(W128,W129,N128,N129,G128,G129,AF117,AF118,Y117,Y118,P117,P118,I117,I118,AI106,AI107,AB106,AB107)>=5,round(SUM(T128:AC129,C128:Q129,AF117:AH118)*0.05,2),"")

 

[Peter_SSs]

Welcome to the MrExcel board!
Try

=IF((COUNT(W128:W129)>0)+(COUNT(N128:N129)>0)+(COUNT(G128:G129)>0)+(COUNT(AF117:AF118)>0)+(COUNT(Y117:Y118)>0)+(COUNT(P117:P118)>0)+(COUNT(I117:I118)>0)+(COUNT(AI106:AI107)>0)+(COUNT(AB106:AB107)>0)>=5,
ROUND(SUM(T128:AC129,C128:Q129,AF117:AH118)*0.05,2),"")

 

[beekerdale]

Peter,, That is amazing and it works Perfect!
Thanks, Dale

 

[Peter_SSs]

Peter,, That is amazing and it works Perfect!
Thanks, Dale

You're welcome. Thanks for the confirmation.