Can I add IFERROR to the following formula? I've tried but keep getting to few arguments. As it is it returns a DIV error until cells are populated.
=(BJ68-SUMIFS(BN4:BN66,AQ4:AQ66,"<"&BI3,AQ4:AQ66,">0"))/COUNTIFS(AQ4:AQ66,"<"&BI3,AQ4:AQ66,">0")
I'd like it to show zero.
Last edited by Marvo; 03-25-2024 at 08:54 AM.
=IFERROR((BJ68-SUMIFS(BN4:BN66,AQ4:AQ66,"<"&BI3,AQ4:AQ66,">0"))/COUNTIFS(AQ4:AQ66,"<"&BI3,AQ4:AQ66,">0"),0)
should do it.
Rory
It works. Thank you. I was missing the second opening bracket at the start of the formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks