SUMIF question

**Jeremy.Waller** · 09-07-2008, 11:13 PM

Hi All,

I have a workbook of 13 sheets, the first being a summary and the next 12 being JAN, FEB, and so on till DEC.

What I need to do is SUM the values of B5:B29 and C5:C29 on all of the monthly sheets if the date in the same row on Colum A is the current calander month, and secondly if it is within the past 30 days.

I have had trouble using TODAY() within the criteria for a SUMIF function.

**sglife** · 09-07-2008, 11:38 PM

I can only give you the formula for 1 worksheet, you have to sum up all the 12 worksheets yourself


=SUM(IF(MONTH(A1)=MONTH(TODAY())*(TODAY()-E!A1<=30),E!B5:C29,0))

**Jeremy.Waller** · 09-07-2008, 11:55 PM

Thanks for your help, But i don't think i described the problem well enough. I've attached the woorkbook i'm working with.

I need the blank cell F11 on the summary page to reflect the # of to/ldgs from the other pages, when those occur within the current calander month. So that's Colums B & C but only when the date in colum a is within the current calander month.

The 30 Day issue arrives for H11 and H12

**sglife** · 09-08-2008, 01:22 AM

I have write 2 sample formulas only include January, you can add other months.
Remember to see the comment

**Jeremy.Waller** · 09-08-2008, 09:58 AM

Thank you, those formulas work great. However, is there a way I can add the other months so they total the same way, in the same cell. Or will i have to combine all 12 months of log entries on one sheet and simply label it 2008?

This formula should work no? But I get a #REF error

=SUM(IF(MONTH(JAN:DEC!A5:A29)=MONTH(TODAY()),JAN:DEC!B5:C29,0))

Thanks again for your help!