Thread: [Solved] Sum based on starting no. of codes
View Single Post
 
Old 03-11-2024, 06:32 AM
Parle Parle is offline Windows 10 Office 2021
Novice
  
Join Date: Mar 2024
Posts: 12
Parle is on a distinguished road
Default
Dear xor,

Result is same as was expected. However need 4 & 5 series total in one cell only. Is it possible like ---> (--LEFT($B$26:$B$34)=4 & 5) to combine the result of 4 and 5 series in one formula only rather to put in 2 different formula for 4 & 5 series respectively ?
Reply With Quote