LinkBack URL
About LinkBacks
I don't think so you need to go for UDF.
Non Array Approach
Formula:
=IF(B2<0,"",A2/SUMPRODUCT(--($B$2:$B$4>0),$A$2:$A$4))
I don't think so you need to go for UDF.
Non Array Approach
Formula:=IF(B2<0,"",A2/SUMPRODUCT(--($B$2:$B$4>0),$A$2:$A$4))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks