#1   Report Post  
Old May 9th 08, 04:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 20
Default 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!

  #2   Report Post  
Old May 9th 08, 04:53 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 168
Default Sumif date range

=SUMPRODUCT((S1:S10TODAY()-365)*(S1:S10<=TODAY())*(K1:K10))
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DB74" wrote:

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!

  #3   Report Post  
Old May 9th 08, 06:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 20
Default Sumif date range

Thnaks for your help! This worked great.

"KC Rippstein" wrote:

=SUMPRODUCT((S1:S10TODAY()-365)*(S1:S10<=TODAY())*(K1:K10))
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DB74" wrote:

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
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
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 05:12 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017