I try to sum only positive numbers from a few cells.
How can I do it?
=SUMIFS(K32,K18,K12, ">0")
I try to sum only positive numbers from a few cells.
How can I do it?
=SUMIFS(K32,K18,K12, ">0")
try:
=INDEX(SUM(IF({K32;K18;K12}>0, {K32;K18;K12}, )))
or:
=SUM(FILTER({K32,K18,K12}, {K32,K18,K12}>0))