Use count in multiple tables

[a1b2c3d4e5f6g7]

Hi,

I would like to count the zero in multiple places. How would you formulate this? I get the error using to many arguments. In the sheet countif the formula.

See example

[Pete_UK]

Try it like this:

=COUNTIF(Sheet1!A2:J2,0)+COUNTIF(Sheet1!A5:J5,0)

You will probably need to change the commas to semicolons.

Hope this helps.

Pete

[Ali Kırksekiz]

Please Login or Register  to view this content.