COUNTIF: everything in a row larger than zero over multiple worksh

Y

Yannig

Hi,

I have a workbook with the first worksheet (main) as a general worksheets
containing the results. All the other worksheets contain scores (SBOz1,
SBOz2, SBOz3, ...). In the scores worksheets each row represents a player,
and each column the score. The first column is the player name.

In the main worksheet i'd like to count all the numbers bigger than 0 for
every player.

The formula i have is:
=COUNTIF(SBOz1:SBOz6!2:2;">0")
Which returns #VALUE.

This formula works fine for any worksheet, but i'd like to count in all the
worksheets at once.
=COUNTIF(SBOz1!2:2;">0")

I can't put a total in the worksheet itself and then count in the main
worksheet since i don't know how many columns (and rows) will be used.
Furthermore, i have other formulas which count the complete row. This one for
example: =AVERAGE(SBOz1:SBOz6!2:2)
Which works fine.

I have to be able to copy the formula down for each player (3:3, 4:4, etc).

I hope i'm just missing one simple thing ;)

Kind regards,

Yannig
 

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

Similar Threads

need help on either doing a loop and counting specific values orusing subtotal function 2
Remove Identical words 0
return multiple values when within range (greater than and less than) 11
Formula: Counting Cells on Different Worksheets 3
Multiple VLOOKUP in an IF statement 2
Counting multiple occcurrences between date range 3
Find the last 4 cell entries in a row 2
Countif until a number occurs four times in a row then return that number 3

Top