Not too clear a question.
Is this what you want?
=SUM(IF(C1:C10=LEFT(B1:B10,3),A1:A10))
This is an array formula and must be entered with CSE (<Ctrl> <Shift>
<Enter>), which will *automatically* enclose the formula in curly brackets
( {} ) if done correctly.
This will add all the cells in A1 to A10, in which the adjoining column B
row's first three characters match the adjoining column C row's three
characters.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I would like to place a sumif in A1 if the left 3
characters in cell B1 equal C1 ?
Thank you in advance
