I have a sheet with dropdown boxes that have selections of "new, used, pending, purchase" in column E3:E63, I also have dropdown boxes in F3:F63 with "no, chanin, tim, mark, chris, isaac"
For example when I select the dropdown box in column E3 to be "new" and F3 to be "no" I need it to tally just 1 unit. When I select E4 as "new" and F4 as "Chanin, Tim, Mark, Chris or Isaac" I need it to register as .5 of a unit. I need help!
For example when I select the dropdown box in column E3 to be "new" and F3 to be "no" I need it to tally just 1 unit. When I select E4 as "new" and F4 as "Chanin, Tim, Mark, Chris or Isaac" I need it to register as .5 of a unit. I need help!
