Forum Discussion
Get sales data for last year but in the next 12 weeks of todays date
Hi all, I'm trying to get the summed sales data for products that occurred in the last year but for the next 12 weeks of todays date e.g. todays date is 10th June 2024, I would want the sales from t...
Hi, please see attached workbook with proposed solution:
=SUMIF($A$1:$A$48,"<"&EDATE($E$1,3),$B$1:$B$48)
How would this work for individual products e.g. just for apples or oranges in my example
Thanks for clarifying that. I still don't think I have it right. Can you look the attached file. It is the full data with 2 sumif attempts. 'Test 2' is your formula. Thanks.
https://1drv.ms/x/s!AuBDc9CKOEvdgmjv4ygQf_al4NTe
