It will work with the correct syntax, but the results will not be the same.
With your sumif formula, for date 02/04/19, the result is (58+52)/((65+68)-(2+10))
With sumproduct for the same date, it would be (58/(65-2))+(52/(68-10))
To achieve the same result as your formula with sumproduct would require a formula far less simple than your existing one.
Additionally, sumproduct will take longer to calculate than sumif with large volumes of data.
With experience, you will discover that the simplest formula is not always the shortest one, or the most pracrical.
Bookmarks