LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 19th 20, 08:24 PM
First recorded activity by ExcelBanter: Aug 2007
Posts: 83
Default 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:


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.

Thanks for your help,

  #2   Report Post  
Old June 23rd 21, 03:59 PM
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default 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:


With that, it will only add negative numbers.

You can also check this out to learn more about SUMIFS Function in Excel.

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
I get some negative numbers when I use the RAND() function--Why? CaliDave Excel Worksheet Functions 4 June 6th 06 01:20 AM
how do i use excel's natural log function with negative numbers? Craig Excel Worksheet Functions 7 April 18th 06 08:39 PM
Erf (the error function) for both negative and positive numbers Kara Excel Discussion (Misc queries) 0 February 7th 05 01:11 AM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM

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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017