troubleshooting Question

Excel Sumif #Value May need Sumproduct

Avatar of avgplusguy
avgplusguyFlag for United States of America asked on
Microsoft ExcelMicrosoft Office
5 Comments1 Solution11 ViewsLast Modified:
Excel 365 Win10
=SUMIFS(Act!$D$1:$AT$23, $D$1:$D$23,"=Product A*",Act!Q$1:$$AB!,"<=$b$8",Act!Q$1:$$AB!,">=datevalue(year($b$8),1,1))TestLine.xlsx
I want to sum all values for Product A and its variations YTD
$B$8 is cell where user puts the current month m/d/yyyy
Q1:AB1 standard first of month data 1/1/2021, 2/1/2021 etc
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros