I have the name Matt in column B in different spots, example B15, B29, B63. In the cell in column C next to the columns that contain "Matt" in column B, some of them contain the value "X". I need to add all the X's in column C that have "Matt" in the column B next to it. I need to do this on all sheets.
Example
B12 = Matt
C12 = X
B13 = John
C13 = X
B14 = Matt
C14 =
B15 = Matt
C15 = X
The answer would be 2.
I know if may have to do this for sheet1 and then add it to sheet2 and so on to get the total, unless there was a way to just add it in the formula where it does it for the entire workbook.
Thanks for help
Bookmarks