ANSWERS: 1
  • You can only sum numbers, so you will have to come up with a system that has only numbers in the column to be summed. For example, you could have the numbers in one column and the text in an adjacent column. If ALL of your entries start with a single figure between 1 and 9 you could use the LEFT function to copy that figure into a different column and then sum those figures. Using something like this will strip out the single number: =VALUE(LEFT(A1,1)) Copy that down as far as you need and you will be able to use the SUM function to add them up.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy