How to Count Data Across Sheets

[SparkLeMur]

Working on a project, and I need to count how many times different keywords are entered across sheets. I know I could just Click on each sheet and select each individual title, but that isn't efficient because I have to deal with over 100 different data points over a years worth of data. Is there any formula I could use to assist me? I've tried COUNTIF but I don't know if I used it correctly.

If I wasn't clear, this is what I mean.

Sheet A has a list of keywords, sheet B-D have those keywords interspersed with other Data. How do I count how many times the keywords appear on sheets B-D without individually selecting on each sheet

 

[JLGWhiz]

A short macro might be your best bet, if you can use macros. This assumes that your keywords are listed in column A of sheet 1.

Sub countKeywords()
Dim c As Range, i As Long, cnt As Long
    For Each c In Sheets(1).Range("A1", Sheets(1).Cells(Rows.Count, 1).End(xlUp))
        For i = 2 To 4
            cnt = cnt + Application.CountIf(Sheets(i).UsedRange, "*" & c.Value & "*")
        Next
        c.Offset(, 1) = cnt
        cnt = 0
    Next
End Sub

 

[SparkLeMur]

I have no idea how to use macros so this probably wont work

 

[SparkLeMur]

I have no idea how to use macros so this probably wont work

 

[JLGWhiz]

I have no idea how to use macros so this probably wont work

Makes us even. I have no idea how to write a formula to do what you want.
Regards, JLG