How to sum only positive numbers from a few cells (not a range)?

Viewed 154

I try to sum only positive numbers from a few cells.

How can I do it?

=SUMIFS(K32,K18,K12, ">0")

1 Answers

try:

=INDEX(SUM(IF({K32;K18;K12}>0, {K32;K18;K12}, )))

or:

=SUM(FILTER({K32,K18,K12}, {K32,K18,K12}>0))
Related