excel how to add text in columns
 

I want to be able to add up column "d" and every cell that has "ROY" in it
to be able to copy assocaiated name in column "A" and display in where
"value" is.



TOTAL MON TUE WED THU FRI #VALUE!
LOADS
ROYAL OAK LDS REQ PER DAY 40 8 8 8 8 8
LDS SHCEDULED 26 7 6 3 6 4
NELSON LDS REQ PER DAY 10 2 2 2 2 2
LDS SHCEDULED 5 1 1 1 1 1
SOUTHFIELD LDS REQ PER DAY 5 1 1 1 1 1
LDS SHCEDULED 5 1 1 1 1 1
ONYX LDS REQ PER DAY 7 1 2 1 2 1
LDS SHCEDULED 4 1 1 0 1 1
SAGINAW LDS REQ PER DAY 0 0 0 0 0 0
LDS SHCEDULED 0 0 0 0 0 0

DRIVERS MON TUE WED THU FRI
Sean Abercrombie ROY
Angela Baker
Bob Brand ROY
Nick Brandis
Ron Brown
Bill Cadman
Kevin Cahill ROY ROY ROY
Gerald Cartmale
Terry Condy
Kelly Cook
Ed Courty
Romeo Courty
Geroge Dakin NEL NEL NEL