Excel Forum

Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)

See how to look through a list of Invoice numbers and add only the ones that have a Prefix of 55 or 58 or 7E.

Learn about how Excel treats numbers and text differently. For example "55" does not equal 55. This matters for TRUE FALSE formulas.

See why SUMIF function will not work, but SUMPRODUCT and LEFT functions will work. This is from a post at the Mr Excel Message Board.

Got a Question? Ask it Here in the Forum.