Is there a way to simplify this formula: =SUMIF(C4:C9,"<0")+SUMIF(G3:G9,"<0") ?
Is there a way to simplify this formula: =SUMIF(C4:C9,"<0")+SUMIF(G3:G9,"<0") ?
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.
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.
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.
Another way to achieve this by using this array formula and need to confirm with Ctrl+Shift+Enter
![]()
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
In the actual model, there are other data columns between the formula columns.
Last edited by Phil Hageman; 12-19-2013 at 10:31 AM. Reason: spelling
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks