It's tough to describe in a title and I did a quick mock up sheet to show what I need.
Column B shows the names of the sales people
Column C is the date of sale
Column D is which red part they sold (Part A or Part B)
Column E is the points awarded depending on a Red A or Red B
the remaining columns F thru I follow the same pattern with different colored parts.
again, this is widgets or whatever.
Cell S3 should calculate all the points Bob has accumulated in columns E,G and I while ignoring errors, blanks...everything but those numbers.
Cell T3 for Tom and Cell U3 for Mark.
I've tried several different ways but even when I get it to work for the first line i have trouble if the sheet was to go past that. I've included a sample sheet. Any help is appreciated.
Bookmarks