The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers
«
»

Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet

Posted by jpluimers on 2020/03/31

As I need this one day:

To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:

=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))






Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet




–jeroen




						

				 		This entry was posted on 2020/03/31 at 12:00						and is filed under Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development.
												You can follow any responses to this entry through the RSS 2.0 feed.

													You can leave a response, or trackback from your own site.

									


	


		
		

		
Leave a comment 







			
			


	

	
This site uses Akismet to reduce spam. Learn how your comment data is processed.

			
« 

			
 »