Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old June 23rd 21, 04:12 PM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default 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!


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 date range DB74 Excel Discussion (Misc queries) 2 May 9th 08 06:56 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 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 12:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017