Hello,
I am trying to get to a composite rate that has different sites, different weights and different contractors.
I tried the following formula but it would not take:
=sumifs(sumproduct(B9:B21,F9:F21),C9:C21,"X")+sumifs(sumproduct(D9:D21,F9:F21),E9:E21,"X")
See attached. Formula should go in the highlighted cell.
Thanks for all the help I can get.
Bookmarks