sumif and left

  • Thread starter Thread starter Bonita
  • Start date Start date
B

Bonita

col a col b
103 100
204 500

need to sum col b based on the first left character of col a
ie 1 100
2 500
 
Back
Top