COUNTIFS to count data in two columns based on other criteria?

Hi

Im having problems with COUNTIFS and multiple criteria. I am trying to count the number of times a name appears in two columns D:E, this based on the date (Month / Year),
The formula is on the "Stats" sheet, along with the cells to select the Year etc.

Im struggling to describe well so i have attached a copy to show what i mean (unfortunately have had to sanitise it somewhat). There is a note in the relevant cell.

Hope you can help (you have never let me down before)!

Thanks in advance.

Si

Hi Dilipandey

Thanks

I am expecting the total number of times the word BAXTER appears in columns D:E on the DATA sheet to be displayed in E9.

The reason i have referanced "Baxter" to the Validation sheet is because "Baxter" should not appear on the Stats page, the Numer 1715 in E3 refers to a person named Baxter (I just put that in to show that). The columns D:E on DATA are validated to only accept names in that list.

I know its probably not the best way!

Benishiryo

Thanks, This works. Will have a look at sorting the validation issue as mentioned by you and dilipandey.

Great stuff yet again.

Originally Posted by benishiryo

hi Si, your formula seems to be correct. Just need to fix some cells. And as dilipandey mentioned, you probably wanna refer "Baxter" in "Stats" instead of the "Validation" worksheet. but following your formula, here it is:

Please Login or Register  to view this content.