SUMIF and range

C

Compass Rose

Is it possible to have non-contiguous (I think that's the right word) ranges
in a SUMIF statement? If so, is this the correct syntax to define the range?
For example:

=SUMIF(A2:A14,A17:A25,">0",R2:R14,R17:R25)

TIA

David
 
P

Peo Sjoblom

Try


=SUM(SUMIF(INDIRECT({"A2:A14","A17:A25"}),">0",INDIRECT({"R2:R14","R17:R25"})))

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif and Specified Ranges 2
sumif with multiple critera range and sum_range 5
SUMIF across worksheets 2
Looking up a returned value defining a named range 2
Sumif function 2
Creating Range Arguments for use in function statements 4
Sumif with named range of nonadjacent cells. 6
SUMIF and a criteria range 3

Top