Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
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,948
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
 



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 07:22 AM.


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