sum occurences meeting criteria by ID, then count how many

[mistert]

Hello.

I have a spreadsheet that has individuals with multiple records indicated by ID in column A and days between outpatient clinic visit and hospital admission in column B.

I would like to know how many individuals had 0, 1 or >1 clinic visits 90 days or less from hospital admission. So I need to sum clinic visits <=90 days by ID, and then count how many individuals (unique IDs) have 0, 1 or >1 visits.

Thanks!

ID Days
1 187
1 160
1 92
1 71
1 50
2 43
2 33
2 8
3 273
3 217
3 175
3 119
4 325
4 152
4 68

[JohnTopley]

Duplicate post.

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.