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

=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.

Thanks for your help,
Keyrookie

  #2   Report Post  
Old June 23rd 21, 03:59 PM
Member
 
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:

A2<-1

With that, it will only add negative numbers.

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

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

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


Reply
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 02:11 AM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 07:23 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 04:02 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017