ExcelBanter - sumif and left

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumif and left (https://www.excelbanter.com/excel-discussion-misc-queries/247745-sumif-left.html)

BONITA

sumif and left

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

--
Bonita

Mike H

sumif and left

Hi,

This works for your posted data

=SUMPRODUCT((INT(A1:A10/100))*(B1:B10))

Mike

"Bonita" wrote:

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

--
Bonita

All times are GMT +1. The time now is 07:21 AM.