Avatar of Theva
Theva
Flag for Malaysia asked on

Convert "SUMPRODUCT" formula to "SUMIF"

Hi Experts,

Any possibilities to convert the listed formula into SUMIF?

=SUMPRODUCT(('Daily Tracking List'!$D$2:$D$41='Summary Report'!$A4)*('Daily Tracking List'!$F$2:$F$41='Summary Report'!B$2)*'Daily Tracking List'!$H$2:$H$41)*1440

Open in new window

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Theva

8/22/2022 - Mon
amrish80

amrish80

Wayne Taylor (webtubbs)

Not with the 2 criteria ranges. Why change it anyway?
Your help has saved me hundreds of hours of internet surfing.
fblack61
Theva

ASKER
Hi webtubbs,

Intended to create a similar line chart as in “Channel Downtime (All)” but without having multiple tables. By having “SUMIF” we could select the “Yes” or “All” (Column-I) when selecting downtime for Channels. Hope this is possible. I am trying to avoid creating additional sheets when dealing archive data. If you have better idea to handle this please do share with me. I have attached my current workbook for your perusal.
Report-2010--Test-.xls
ASKER CERTIFIED SOLUTION
zorvek (Kevin Jones)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Theva

ASKER
Thanks a lot.