![]() |
|
#1
|
|||
|
|||
![]() 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!D5 ![]() 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 ![]() |
#2
|
||||
|
||||
![]()
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") 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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
sweetcuda | Excel | 13 | 08-26-2013 11:09 AM |
![]() |
docwhit | Excel | 2 | 01-05-2013 12:58 PM |
![]() |
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 |