Posted to microsoft.public.excel.misc

DB74

external usenet poster

Posts: 20

Sumif date range

I have a list of revenue by dates (mmyy) and want to have a function that
will calculate my revenue for the last 12 months as of today. Can anyone
help with the syntax of this function? My dates are in column S and my
revenue figures are in column K.

Thanks for your help!

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
Sumif date range	Delsy	Excel Worksheet Functions	6	March 22nd 12 05:51 PM
SumIf with date range	juliejg1	Excel Worksheet Functions	5	December 12th 07 09:23 PM
Sumif for Date Range	Raza	Excel Discussion (Misc queries)	3	April 11th 07 04:32 PM
Sumif with two criteria including a date range	Ladyofthewhitecity	Excel Discussion (Misc queries)	4	February 4th 07 09:53 AM
SUMIF within date range as a function of today()'s date	irvine79	Excel Worksheet Functions	8	August 6th 06 05:55 PM

All times are GMT +1. The time now is 04:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us