Formulas

Hi Anthony

Thanks for getting back to me,

I have a list of names on a spreadsheet where i want a total at the bottom of the number of cells with names in as they are everchanging and i dont want to physcially count it up everytime i want to add a new name/remove one.

I found that if i was totaling multiple names i.e. from A1 to A21 it was fine however my column of totals is broken into department where there may only be 1 name in one of the departments meaning i only want to add 1 to my toal i.e. cell ref A22. Ive done a sort of example below,

Dept 1
name
name
name

Dept 2
name

It doesnt let me include just 1 cell there has to be multiple.

Thanks
Beckie