SUMIF with non-adjancent cells

  • Thread starter Thread starter ismae
  • Start date Start date
No, I mean when the "range" and "sum_range" contain non-adjacent cells. For
example, I want to sum from cells C5,G5,K5,O5,.....,AI5 only the ones with
positive values. I tried the formula

=SUMIF((C5,G5,K5,O5,S5,W5,AA5,AE5,AI5),">0",(C5,G5,K5,O5,S5,W5,AA5,AE5,AI5))

but it returns #VALUE!
 

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 of non-adjacent cells 1
SUMIF formula with non contiguous cells 2
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SUMIF with criteria "<>" & "=" 4
SUMIF on a Calculated Field 3
SUMIF ERROR 3
How to use SUMIF function with non-adjacent cells 5
SUMIF and range 2

Back
Top