Hi guys, little help with a formula please...
I currently have:
=IFERROR(SUM((IF(B6="y",5,0)),(IF(C6="y",5,0)),D6,E6*2,F6*3,G6*4,H6*6,I6*7,J6*10),"")
which does everything I need it to do APART from:
- IF the range is BLANK, return blank, not 0.
What do we do this formula to return blank? Without arrays pls.
Attaching a file too.
Thanking in advance!
https://www.excelforum.com/attachmen...1&d=1618398015
Please try
=IFERROR(1/(1/SUM(COUNTIFS(B6:C6,"y")*5,SUMPRODUCT(D6:J6,{1,2,3,4,6,7,10}))),"")
or
=SUM(COUNTIFS(B6:C6,"y")*5,SUMPRODUCT(D6:J6,{1,2,3,4,6,7,10}))
and custom format #
I just put this simple if sum in front and that took care of it for me...
=IF(SUM(B6:J6)=0,"",IFERROR(SUM((IF(B6="y",5,0)),(IF(C6="y",5,0)),D6,E6*2,F6*3,G6*4,H6*6,I6*7,J6*10),""))
hope that helps.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Amazing, thank you so much guys! Greatly appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks