names in sum code

[hel]

Greetings
I use the code below to look up totals of overdue amounts - in the code below for 61 to 90 days
This is fine but I would like to use a similar formula to look at individal amounts

e.g. Bill smith [in col f] - [how much in 61 to 90 days]
Please how do I add to the code below to achieve this please
All the names are in col f

Hel

[teylyn]

Hard to tell what you want to do without seeing an example. Maybe

=SUMIFS($P$19:$P$244,$S$19:$S$244,">61",$S$19:$S$244,"<=90",$F$19:$F$244,"Bill Smith")

If that's not it, please attach a workbook with some sample data and mock up the expected result manually.

[hel]

Thanks for that.
It works provided I go down each row and alter the "Bill Smith" to the actutal name
Is it possible to cell reference Bill smith to say F254 with the next row looking for F255

Hel

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[hel]

Sorry.
I should have given an example.
refer to attached.
Now the cell references are correct for my worksheet what I am searching for is replacing the Bill Smith with a cell reference so I doun't have to alter each line with a new name

Hel

[teylyn]

can you come up with a few dummy names instead of xxxxxx? It's impossible to test anything against that.

Also:
- where would the formula go?
- why do you mention " F254 with the next row looking for F255". What is in column F?

Come up with a data sample that has real data. Anonymize, by all means, but give us something to work with.

Identify the range where you want the formula applied
Mock up a few results manually, so we can check that the suggestion delivers what you want.

Help us help you!