How to sum up or count matching criteria from one page into a table in another page

Good Morning

I'm trying to count or sum up information from one page into a summary tabel in another page and am getting stuck.

I have info in:

A2:A100 is names of people
B2:100 is months

This is the information I am trying to place into a table that matches the name of the person and if the month is say July for Lisa (see attached sheet)

So if A5 = Lisa and if B5 = July, on the Name and Month tab, then I'd like it to go into the table on the summary tabe. Lisa's name is in the summary table in B6 and I'd like July to be counted and go into E6 The same process would happen for all of the months to be counted that matches any name in the name and month tab and placed into the summary tab that matches the names to the month.

I've tried using the countif and sumif, but I seem to be missing something and I'm not sure what it is.

I hope I'm making Sense - thank you in advance for your help

Try this in Sheet "Summary" B3

Please Login or Register  to view this content.

or if you don't want to return zeros

Please Login or Register  to view this content.

Drag/Fill Across to M3, then down as required.

You have trailing space in several of your cells, hence the addition of TRIM() to the above formulae.

Is this what you are looking for?