select multiple cell ranges in "sumif" formula?

G

Guest

I am trying to sum all numbers <0 using the SUMIF formula in Excel 2003.

FORMULA: =sumif(range,criteria,sum_range)

I got it to work, but I have cell ranges to total that are not next to each
other (such as A5:A15 and C5:C15).
When selecting the ranges for the formula, Excel writes them A5:A15,C5:C15

because of the comma (,) between the cell ranges Excel is reading the A5:A15
as the range and C5:C15 as the critera. How can I get this formula to allow
me to select multiple cell ranges?

All help is appreciated.

Thank you.
 

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

Rank Function: Refer to more than one range 4
Excel SUMIF formula statisfying two conditions in two columns? 14
Sumif and Specified Ranges 2
sumif with multiple critera range and sum_range 5
using sumif & countif to sort multiple cells 3
Sumif across multiple ranges 3
Formula Help 0
SUMIF ranges 2

Top