Names and numbers in different cells

S

Shirl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum in another cell with reference to another 1
Total columns Based on another cells value 4
Two different totals in one cell 2
find last populated cell in range of cells 6
time blocking calendar 0
Add cells using a diffrent column as the criteria 1
Combine text under different condition 3
Macro for merging rows 4

Top