![]() |
|
#3
|
||||
|
||||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
SumIFS statement (not sure if it is right use)
|
sweetcuda | Excel | 13 | 08-26-2013 11:09 AM |
I need help with =SUMIFS
|
docwhit | Excel | 2 | 01-05-2013 12:58 PM |
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 |