I need to sum the line totals for all of the sales codes for a single rep into a cell. I am using an NL function to create the list of sales for all sales reps and then totaling the sales in another sheet for each individual rep. I used SUMIF and that worked with one sales code, but when I used a1|a2|a3 for the sum range, it didn't work.
In the example below, I need to sum all of the sales codes for each rep in the Total Sales Column. What would be the best way to do this? Thanks!
|Rep||Sales Codes||Total Sales|