Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-20-2013, 05:57 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
Exclamation Help with SUMIFS

Heya!



New to these forums, and registered to ask a question about SUMIFS.

I'm working on a some bookkeeping sheets, with a final sheet that acts as a bookend for the year. The bookend is designed something like this:

Sales
Service type 1 ..... X for October ..... X for November
Service type 2 ..... X for October ..... X for November
Service type 3 ..... X for October ..... X for November
Where X is where my SUMIFS function is gonna be. X is also specific for a month, say this October.

My bookkeeping sheet for income and gains is not separated into different months, but they are marked with dates.

Row 5 has the date in column A, the type of service in column F, and the profit in column H.

With that said, I want the SUMIFS function to check if column A, in this example, falls between 2013-10-01 and 2013-10-31 (Swedish standard for dates), and if it is indeed Service Type 1. If these are true, then the profit from the H column will be added. This action repeats in the interval of rows 5-105.

My current formula, which doesn't work properly, is as follows:
=SUMIFS(Intäkter!H5:H105; Intäkter!A5:A105; "=>2013-10-01"; Intäkter!A5:A105; "=<2013-10-31")

So far I've only tried to make the formula work for dates, regardless of the type of service. "INTÄKTER!" is the swedish word for income, and the name of the worksheet.


I'm hesitant to upload the file as it contains some personal information right now, but if this didn't make any sense I can spend some time recreating a similar document so that you can fully understand the problem.

PS: I'm on Office 2013, and I need the solution to be backwards compatible with 2007 and 2010.
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 09:48 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