Microsoft Office Forums - View Single Post - [Solved] Sum based on starting no. of codes

Thread: [Solved] Sum based on starting no. of codes

View Single Post

Old

03-25-2024, 08:51 AM

xor

xor is online now

xor uses Windows 11

Windows 11 xor uses Office 2021

xor uses Office 2021

Office 2021

Expert

Join Date: Oct 2015

Posts: 1,102

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Or

=SUMPRODUCT(($B$4:$B$47880=$E$3)*(LEFT($A$4:$A$478 80)={"4""5"})*$C$4:$C$47880)

where {"4""5"} for you should be {"4","5}

Reply With Quote