Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2016, 03:27 PM
Haha88 Haha88 is offline Sumif with Conditions Windows 8 Sumif with Conditions Office 2010 32bit
Advanced Beginner
Sumif with Conditions
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default Sumif with Conditions

Hi,



I'm looking for a sumif function but with an additional condition, for example: exclude negative balance in the formula.

I attached the workbook and hope someone can help please.

Thank you
Attached Files
File Type: xlsx Sumif test.xlsx (31.8 KB, 7 views)
Reply With Quote
  #2  
Old 12-19-2016, 11:34 PM
xor xor is offline Sumif with Conditions Windows 10 Sumif with Conditions Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

See attached workbook
Attached Files
File Type: xlsx Sumif_test_2.xlsx (30.6 KB, 15 views)
Reply With Quote
  #3  
Old 12-21-2016, 12:08 AM
Haha88 Haha88 is offline Sumif with Conditions Windows 8 Sumif with Conditions Office 2010 32bit
Advanced Beginner
Sumif with Conditions
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
See attached workbook
Perfect! thank you very much!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another SUMIF OTPM Excel 6 06-06-2016 03:00 AM
VBA sumif Nisio07 Excel Programming 0 02-26-2016 07:53 AM
HELP - SUMIF more than 3 conditions + operations in the sum romelsms123 Excel 0 06-23-2014 09:59 AM
Need help sumif with variable for VBA jingo Excel Programming 4 01-23-2014 11:02 AM
Sumif with Conditions Average if and sumif jennamae Excel 4 01-17-2014 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft