Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2013, 06:08 AM
LeFoah LeFoah is offline Help with SUMIFS Windows 8 Help with SUMIFS Office 2013
Novice
Help with SUMIFS
 
Join Date: Oct 2013
Posts: 2
LeFoah is on a distinguished road
Default


In a furious troubleshooting spree I found a workaround, which may not be the optimal way to do things, but it worked for me:

=SUMIFS(Intäkter!H5:H105; Intäkter!A5:A105; ">2013-09-30"; Intäkter!A5:A105; "<2013-11-01"; Intäkter!D5105; "=Översättning SVE-ENG")

I removed the "equal or greater" and "equal or less" with "greater" or "lesser", and moved the dates to the last of the previous month, and the first of the following month. And then I could add my 3rd criteria that checked the type of service and it all worked flawlessly. Such a relief In case someone has similar issues I thought I'd let the thread be and add this, instead of editing and removing the original post.
Reply With Quote
  #2  
Old 10-20-2013, 09:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with SUMIFS Windows 7 64bit Help with SUMIFS Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hej LeFoah

your solution looks ok and thank you for sharing it
You can shorten it a bit using sumproduct like this for october
Code:
=SUMPRODUCT((Intäkter!H5:H105)*( MONTH(Intäkter!A5:A105)=10)*Intäkter!D5:D105="Översättning SVE-ENG")
or replace 10 with MONTH(your_ref)

I find sumproduct more flexible than SUMIFS, but maybe it's slower
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with SUMIFS SumIFS statement (not sure if it is right use) sweetcuda Excel 13 08-26-2013 11:09 AM
Help with SUMIFS I need help with =SUMIFS docwhit Excel 2 01-05-2013 12:58 PM
Help with SUMIFS SumIFS Questions Kheinrich119 Excel 2 12-12-2012 10:00 AM
Help needed using the serial number date with sumifs - whole office is stumped FraserKitchell Excel 3 01-06-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:57 PM.


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