![]() |
#1
|
|||
|
|||
![]()
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 NovemberWhere 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. |
|
![]() |
||||
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 |