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.
|
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! |
All times are GMT +1. The time now is 11:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com