B
Bobby
Hello
I am using the formula
SUMPRODUCT(($F$3:$F$178="7-F")*($G$3:$G$178="A")*H3:H178) on a file of
imported values. This works fine except cells with invalid data as shown by
*, which gives me #Value. How should I modify my formula to ignore the
invalid data.
Thanks!
I am using the formula
SUMPRODUCT(($F$3:$F$178="7-F")*($G$3:$G$178="A")*H3:H178) on a file of
imported values. This works fine except cells with invalid data as shown by
*, which gives me #Value. How should I modify my formula to ignore the
invalid data.
Thanks!