Hi there thanks for responding. It's a simple enough formula. I'm assigning tasks to people and want to sum the amount of time they are allocated in any one day in order to ensure I'm not overbooking them. Here is the formula.
=SUMIF($H$4:$W$461,$G465,AD$4:AD$461)
The H to W - references the area where I assign by a persons initials - there are 16 in total
The G reference - refers to the cell where an individuals initials are e.g. NP
the AD to AD - refers to the column with all items assigned on a date e.g Jan 24th
So I'm asking the formula each time you see an instance e.g. NP ($G465) in $H$4:$W$461 sum all numbers in AD$4:AD$461.
I have therefore 16 rows counting assigned time for each person for each day. The first row seems to be working however the subsequent ones are acting strangely for example if I'm in Cell AA468 and the formula is =SUMIF($H$4:$W$461,$G468,AA$4:AA$461) it is actually counting entries from future columns e.g. AB or AD - this varies through sometimes a column ahead sometimes several.
I'm wondering if this is a result of a drag and drop at some point. But given the amount of data I have it would be impossible to find. Any help greatly appreciated. Apologies for the long answer