Hello,
I am using a sumprouct formula to add the contents in G2:G66 where the
first 8 characters of C2:C66 are Subtotal.
=SUMPRODUCT(--(LEFT(C2:C66,8)="Subtotal",--(G2:G66))
My understanding is that bu using the coma rather than * would ignore
text values in G2:G66. However, I am still getting #value be casue of
text values. What is the fix?
Thanks!