Remember Me?

#1
January 14th 14, 04:53 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 48
SUMIF between date range

I have some numbers from a long list of columns that I wish to sum if it falls between years 2003 to 2014. The idea is for the formula to sum only the numbers that fall within a specific year, specifically 2003. The dates are in column (B17:b50000). The numbers are in columns (N17:X50000). It is probably very simple, but I have been banging my head with this one. Just a no go. Can someone help? Thanks.

#2
June 23rd 21, 04:12 PM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
SUMIF within date range

Hello!

I don't think it's possible to do this via SUMIF, but you can definitely do it with SUMIFS.

SUMIFs function in Excel allows for multiple conditions, so basically, just put the 2 dates in between as criterias then you can already do this solution.

I actually learned to do SUMIFs he https://www.efinancialmodels.com/kno...tion-in-excel/

Hope this helps!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Delsy Excel Worksheet Functions 6 March 22nd 12 05:51 PM DB74 Excel Discussion (Misc queries) 2 May 9th 08 06:56 PM juliejg1 Excel Worksheet Functions 5 December 12th 07 09:23 PM Raza Excel Discussion (Misc queries) 3 April 11th 07 04:32 PM irvine79 Excel Worksheet Functions 8 August 6th 06 05:55 PM

All times are GMT +1. The time now is 12:43 PM.