Link to home
Start Free TrialLog in
Avatar of Theva
ThevaFlag 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

Avatar of amrish80
amrish80
Flag of India image

Avatar of Wayne Taylor (webtubbs)
Not with the 2 criteria ranges. Why change it anyway?
Avatar of 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
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Theva

ASKER

Thanks a lot.