Andrey
Andrey

Reputation: 44

How to count appearances of a number in a Different sheet?

How do I count how many times a number appears in a column, in a different sheet than where the formula is.

I can't count it in the same sheet because the first sheet gets sent to people that don't need the count.

Upvotes: 0

Views: 2506

Answers (1)

user4736025
user4736025

Reputation:

Use a sheet reference. =COUNTIF(Sheet2!A1:A10, criteria)

Upvotes: 1

Related Questions