I'm trying to sum the number of sales by product type in a previous year up to and including todays date, ignoring the year. So I want to get todays date automatically, remove the year and
and count the number of sales to 15 Jan for example.
I have this formula, which counts by product type, upto the current date, which is wrong. Can't figure out how to just use the day & Month.
=SUMIF(A1:E1,"<="&TODAY(),A2:E2)
Many thanks
I don't feel like setting up a spreadsheet to test this so I'll tell you how to do it and you can figure it out from my verbal description. It sounds like a combination of TEXT() to separate the date into DD-MM format and SUMPRODUCT or an array formula should do the trick for you.
By removing the year, if you have more than just this year/last year, you could include more than just 1 year's data
Look at using SUMIFS() for this. Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks