I Export the excel file from another program, it has columns b,c,d, and e . The file that I export is based off of sales of brands, there are 100's of brands. Some of the brands may have 1, 2,4 or more entries, between each brand it will have the sum listed in column e. The problem is that column e list the the packs as 1 each and the cartons 1 each. For example one brand may show 1 pack and 1 carton sold and the sum will be 2 in column "e".
So what I Have done is created an if statement to convert the cartons into packs (column f) this part works fine. Now I just need to get the sum of the packs in column "f" for each row that has totals in column "b". here is the if statement i have in column F -----------IF(F4="CARTON",G4*10,(IF(F4="PACK",G4,)))
thanks for your help