Using COUNTIF across sheets

[JStiehl]

Is it possible to use the COUNTIF function with data from different sheets?
Please help with proper syntax if possible. Thanks.

 

[DeanH]

Try asking in the Excel forum, this one is for Word.
And yes I believe you can use CountIf across sheets.

 

[Stefan Blom]

This sounds like an Excel question. You're in the wrong forum.

--
Stefan Blom
Microsoft Word MVP


in message
news:[email protected]...

 

[JStiehl]

Oops--thanks!

Try asking in the Excel forum, this one is for Word.
And yes I believe you can use CountIf across sheets.

 

[Tony Jollans]

Yes.

=COUNTIF(DifferentSheet!A1:A10,"value")