Is there a way to add both text and numers formats together using sumproduct?
C Curtis Oct 29, 2006 #1 Is there a way to add both text and numers formats together using sumproduct?
B Bob Phillips Oct 29, 2006 #2 =SUMPRODUCT(--B5:B10) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) Curtis said: Is there a way to add both text and numers formats together using Click to expand... sumproduct?
=SUMPRODUCT(--B5:B10) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) Curtis said: Is there a way to add both text and numers formats together using Click to expand... sumproduct?
