Combining SUMIF Statements

[Phil Hageman]

Is there a way to simplify this formula: =SUMIF(C4:C9,"<0")+SUMIF(G3:G9,"<0") ?

[Jonmo1]

That formula, probably not.
It's about as simple as it's going to get.

But is that a realistic example of what you want, or a shortened/simplified version?
Are you really wanting to do several columns, like C G K O etc.. ?
Is the pattern consistent (every 4 columns) ?

With the 2 ranges being of different sizes (one is row 4 to 9, the other is 3 to 9),
If that is really true, then there probably won't be a simple solution.
But if that was just a typo, and the ranges actually are all the same size, then something can probably be worked out.

But we need the specific details.

[Phil Hageman]

I set this up as an example - the two ranges are indeed dissimilar. Adding the two SUMIFs was all I could think of and wondered if there might be a more elegant way. Thanks for your time answering.

[Jonmo1]

What is in the cells 'between' the two ranges (D3:F9 and C3) ?
If those cells are NOT numeric, then you can just do

=SUMIF(C3:G9,"<0")

It will just ignore any non numeric values.

[Phil Hageman]

In the actual model, there are other data columns between the formula columns.

[sktneer]

Another way to achieve this by using this array formula and need to confirm with Ctrl+Shift+Enter

=SUM(IF(C4:C9<0,C4:C9),IF(G3:G9<0,G3:G9))