J
janee
I am familiar with COUNTIF - I am trying to count the number of times "x"
appears in the same cell of 7 different worksheets in the same Excel file.
=COUNTIF(Smith!B7:Jones!B7, "x")
I have tried every kind of variation I can think of to make this work. I
have tried SUMIF too. If I change the "x" value in the cell to a number "1"
- it then works with SUM.
Thanks for any insight. I am the IT person helping someone else!
appears in the same cell of 7 different worksheets in the same Excel file.
=COUNTIF(Smith!B7:Jones!B7, "x")
I have tried every kind of variation I can think of to make this work. I
have tried SUMIF too. If I change the "x" value in the cell to a number "1"
- it then works with SUM.
Thanks for any insight. I am the IT person helping someone else!