Hi all, I wonder if someone can help me with this problem. I've created a workbook with 18 sheets. Each sheet is named 1-18 representing 18 tables of 8 people at a function. The tickets sold were either $30.00 or $15.00.
My 19th page is a total page which I've broken down to show each table on a separate row. I've created a =countif formula with the criteria of $30.00 for page 1, but the question I have is, can I use a command to have the next row down countif the same cells but on table 2 and so on.
So I want for example page 19 cell a1 will be =COUNTIF('1'!$J18:$L25,30) in cell a2 I want to copy of drag the formula but to change from "1'' TO "2''
Hope this is clear enough. Thanks in advance.
My 19th page is a total page which I've broken down to show each table on a separate row. I've created a =countif formula with the criteria of $30.00 for page 1, but the question I have is, can I use a command to have the next row down countif the same cells but on table 2 and so on.
So I want for example page 19 cell a1 will be =COUNTIF('1'!$J18:$L25,30) in cell a2 I want to copy of drag the formula but to change from "1'' TO "2''
Hope this is clear enough. Thanks in advance.