Posted to microsoft.public.excel.worksheet.functions

JLR-Mart

external usenet poster

Posts: 24

SUMIFS and dates

I have some data and wish to use the sumifs function to add up sums when a
criteria is true and the date is less than a month ago. I have tried using
date-30 to no avail. Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
SUMIFS formula using dates and text as criteria	Trish	Excel Discussion (Misc queries)	4	May 21st 23 07:46 PM
Using Sumifs	tomferrin	Excel Worksheet Functions	3	April 7th 09 06:40 PM
Sumifs	David	Excel Discussion (Misc queries)	9	January 27th 09 05:20 AM
sumifs, sumif with dates	Richard Manor	Excel Worksheet Functions	6	November 13th 08 12:19 AM
SUMIFS with dates	Chinni Krishna Reddy[_2_]	Excel Worksheet Functions	2	April 16th 07 10:02 PM

All times are GMT +1. The time now is 09:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us