I am trying to add the totals given in Columns C, E, G etc etc of each
suburb listed in columns B,d,F etc etc. When the formula finds the total is
also needs to give me the name in column 1 for that area. (Two areas given in
example but not all week)

Eg: Find "PNS Sound Hutt" in column B, & column D, add 2.0 (from column c)
& (1 from column e) then show John. I need to know how often each person
visits each suburb.

Name Suburb No Suburb No

A B C D E etc etc
John MONDAY 6AM TUESDAY 6AM
PNS Sound Hutt 2.0 PNS Petone 4.0
WW Queensgate 3.0 WW Queengate 2.0
PNS Petone 1.0 PNS Sound Hutt 1.0
PNS Petone 1.0


Robert MONDAY 6AM TUESDAY 6AM
PNS Sound Hutt 2.0 PNS Sound Hutt 4.0
NW Sound Hutt 2.0 CD Sound Hutt 1.0
CD Sound Hutt 1.0 NW Sound Hutt 2.0
PNS Sound Hutt 1.0


--
Shirl, NZ