Notifications
Clear all
Topic starter
Hi,
How can I add a condition to this formula:
=SUMPRODUCT(B3:B113,K135:K245)*SUM(1,SUMPRODUCT(B98:B133,K247:K282))
As in: =SUMPRODUCT(B3:B113,K135:K245) and then Only if the total is greater than 0: *SUM(1,SUMPRODUCT(B98:B133,K247:K282))
Thankyou
Posted : 11/03/2021 6:24 am
No example spreadsheet to check on, but something like the below?
=if(SUMPRODUCT(B3:B113,K135:K245) >0 , SUMPRODUCT(B3:B113,K135:K245) * SUM(1, SUMPRODUCT(B98:B133, K247:K282)), SUMPRODUCT (B3:B113,K135:K245) )
Posted : 11/03/2021 5:58 pm
Or perhaps:
=MAX(SUMPRODUCT(B3:B113,K135:K245),0)*SUM(1,SUMPRODUCT(B98:B133,K247:K282))
Posted : 12/03/2021 7:52 am
