Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 3
Default Help on the Sumif Function

I have a budget table where I input data every week. I want to create another table that shows how much I've spent every month. So for the Month of April my equation looks like SUMIF(Table[Date], MONTH(4), Table[Debit]). My value comes up as zero. Is there a way to make this function work to where I can find the sum sorted by the month?

Last edited by matt_writer : November 8th 12 at 05:08 PM
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 829
Default Help on the Sumif Function

"matt_writer" wrote
I have a budget table where I input data every week.
I want to create another table that shows how much I've
spent every month. So for the Month of April my equation
looks like SUMIF(Table[Date], MONTH(4), Table[Debit]).
My value comes up as zero. Is there a way to make this
function work to where I can find the sum sorted by the month?


The parameter to MONTH should be a date. So MONTH(4) is effectively
MONTH("4 Jan 1900") (not valid Excel syntax), which should always return 1.

But Table[Date] presumably contains complete dates. So value of 1 that
MONTH(4) returns is interpreted as 1 Jan 1900 because you are comparing it
with dates.

What you might want to write is: SUMIF(MONTH(Table[Date])),4,Table[Debit]).
But that is not valid syntax.

Use the following instead:

SUMPRODUCT((MONTH(Table[Date])=4)*Table[Debit])

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to nest a left function within a sumif function? LisaK Excel Worksheet Functions 2 April 23rd 23 11:46 AM
How do I use the TODAY function with the SUMIF function? Lisa B. Excel Worksheet Functions 2 September 30th 05 08:51 PM
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed Excel Worksheet Functions 17 September 19th 05 04:24 PM
Can SUMIF function include AND function ShaneS Excel Worksheet Functions 1 May 17th 05 03:24 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"