[SOLVED] Sumif with Sum_range of only positive amounts

On the attached chart, I need the "Total MRR (+) cell to sum only the positive amounts in column L/M AND only if the text in column N/O contains the text "MRR" and any number next to MRR.

I can then copy this formula for the other totals I need.

I thought I had it using the Sumif, but that only gave me the total of both positive and negative amounts. I need to separate the amounts into negative and positive and then combine to get the net total.

THANKS!

Your attached sheet contains only headers but no data. Please provide a sample workbook with enough sample data in it. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.

I don't do merged cells, but something like

=sumifs(sumRange, sumRange, ">0", critRange, "MRR*")

My Excel is showing it as (Range, criteria, sum range)

That's SUMIF syntax, not SUMIFS.

This works:

Formula:

Please Login or Register  to view this content.

SUMIF and SUMIFS are two different functions.

SUMIF and SUMIFS are two different functions.

SUMIF has the syntax (CRITERIARANGE,CRITERIA,[optional SUMRANGE])

SUMIFS has the syntax (SUMRANGE,CRITERIARANGE1,CRITERIA1,CRITERIARANGE2,CRITERIA2) etc.....until you have entered all the criteria.