Main Profile

At A Glance

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.
Length: 05:29

Contact

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

Want more info about Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question