Hi, I am still learning more advanced excel functions such and Index Match, Sumifs, etc. I have a task which I can't get right. I want to get the total sum when selecting each of the outlets below in Column AH. I need to get this information by using the Cheque number column but it has alpha and numeric in the cell. I know I should be able to use something like sumifs and Left function but I keep getting errors. If I delete the numbers and just have the 3 alpha characters it works but I need to keep as the below because the data comes from an import. If someone could provide the easiest formula for me to input that would be great. I am sure there would be several out there
Small side note, but I am hoping it shouldn't make much different other than tab naming labels, but Column Q, AH and Total Sum below will be on a separate tab, drawing figures from an input tab. I have combined here for easy viewing.
Thanks in advance.
Small side note, but I am hoping it shouldn't make much different other than tab naming labels, but Column Q, AH and Total Sum below will be on a separate tab, drawing figures from an input tab. I have combined here for easy viewing.
Thanks in advance.
CHEQUE_NUMBER | CASHIER_CREDIT | Outlet Column AH | Total Sum | |||
ILK008120210510214224 | 106.5 | ILK | Need Formula??? | |||
ILK008720210510195005 | 93 | ARN | ||||
ILK010820210510211708 | 170 | MAN | ||||
ILK011520210510220706 | 239.75 | BOU | ||||
ILK011720210510223908 | 154 | GEC | ||||
WAL4403520210510112251 | 72 | PIO | ||||
WAL4404520210510125927 | 57 | |||||
WAL4404620210510125236 | 64 | |||||
WAL4405920210510122447 | 42 | |||||
WAL4411920210510153442 | 69 | |||||
WAL4415720210510171928 | 111.5 | |||||
WAL4417620210510184124 | 51.25 | |||||
WAL4419620210510232040 | 76.99 | |||||
WAL4422120210510193742 | 53.18 | |||||
WAL4426720210510215810 | 12 | |||||
PIR4008020210510161506 | 0 | |||||
PIR4006320210510153124 | 0 | |||||
ILK000320210510070414 | 0 |