I have a spreadsheet like this...
............Mon....Tues.
Joe.......yes.......no


Joe.......yes.......yes
Joe.......no.........yes
Joe.......yes.........no
Sally.....no.........yes
Sally.....no..........no
Sally.....yes.......yes
Sally.....yes........no
Sally.....no.........yes
Sally.....yes........no
Sally.....no..........yes
Greg....yes.........no
Greg....no..........no


All the names in the first column are unique. I need to go through the whole spreadsheet and have a simple way to tell me how many yes's or no's each person has on each day of the week like this...
..............Mon..........................Tues.
Joe......yes=3...no=1..........yes=2...no=2
Sally....yes=3...no=4.........yes=4...no=3
Greg....yes=1...no=1.........yes=0...no=2


Is there some macro for this? The spreadsheet is too big to have to go through the whole thing manually trying to get this information.

thanks

If you don't mind slightly rearranging your data, a PT will do the trick easily

Attached Files

Sheet Data.xlsx (12.6 KB, 9 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer, thanks for the help, but having to rearrange all the day columns and their data into one day column would be a lot of work. Is there a way I can do this by keeping all the day columns separate from each other at the top of the spreadsheet?

Can I have the results to be like this...
...............Monday.....Tuesday
...............yes/no.......yes/no
Joe.............3..1..........2...2
Sally............3..4.........4....3
Greg...........1...1.........0....2

thanks

Perhaps you can adapt this to your requirements.
Run the Uniques_From_Column sub first to create the list of names.

Attached Files

ewso.xlsm (17.1 KB, 15 views)