3 dimensional COUNTIF

F

Faraz A. Qureshi

Any idea how to carryout an exercise of counting the number of times an entry
appears in multiple sheets' cells A1?

In other words a formula like:
=COUNTIF(Sheet1:Sheet10!A1,"X")

So as to checkout the number of sheets carrying "X" in their respective cell
A1?
 
J

Jacob Skaria

Hi Faraz

Try this; if your sheets are named Sheet1,Sheet2,Sheet3...Sheet10 etc; then

=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet" &ROW(1:10) &"'!A1"),"x"))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top