Remember Me?

#1
March 19th 20, 08:24 PM
 Member First recorded activity by ExcelBanter: Aug 2007 Posts: 83
Sum only negative numbers in the Sum Range of the SUMIF function

Hey all,

I need to return only negative numbers using the SUMIF function. I can't figure out how to add the second criteria needed to have the formula return only negative numbers. Here's my working formula:

=SUMIF(\$C\$7:\$C\$2000,"paypal*",\$D\$7:\$D\$2000)

So I'm wanting to look up PayPal in column C and then return only the matching negative numbers found in column D. Then I'll need to modify the formula to return the positive numbers.

Keyrookie

#2
June 23rd 21, 03:59 PM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
SUMIFS Is Used for multiple criteria

Hello! For this case, we don't really use SUMIF, but rather, we use SUMIFS.

SUMIFS is used as:

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2...)

so for this case, just do it the same way, then just add the criteria Range, and for criteria2, assuming A2 is the cell:

A2<-1

With that, it will only add negative numbers.

https://www.efinancialmodels.com/kno...tion-in-excel/

Last edited by Wilbur Chua : June 23rd 21 at 04:07 PM

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post CaliDave Excel Worksheet Functions 4 June 6th 06 01:20 AM Craig Excel Worksheet Functions 7 April 18th 06 08:39 PM Kara Excel Discussion (Misc queries) 0 February 7th 05 01:11 AM Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM

All times are GMT +1. The time now is 12:30 PM.