excel counting number of time value appears in workbook

[Trustmeimadoctor]

I have a list of values that I want to count how many times each value shows in the same column in multiple worksheets how do I do this?

[OutInTheShed]

Insert a column
boolean test whether the data is equal to the value in question, that will put a 1 in the new column for every match.
Sum all the 1's to get the number of matches.

If the value isn't exact integers you can change the boolean test to data < (test +.5) AND (data > (test-.5) ) or something like that.

[wiggy001]

countif

[DE1975]

A couple of ways using COUNTIF function

https://www.extendoffice.com/documents/excel/2541-...

[Trustmeimadoctor]

Yeah I did it using countif but tried doing it 3d but it isn't supported so just did multiple countif + to each other in one formula

It worked for the specific issue but would have been nice if it could have dynamically updated when I added in more sheets but never mind