I need help to calculate a few columns, but I don't know how to do it. So:
I have a workbook with 8 sheets - day1, day2, day3, day4, day5, day6, day7 and totalDay.
In each sheet I have same table with 6 columns - column1, column2, column3, column4, column5, column6
Cell in each column is List with only one text. At the end of each column I have funcion to "=COUNTA" to count all filled cells.
Then the sum for each column and each day I save in totalDay with function =+day1!E47+day2!E47+day3!E47+day4!E47+day5!E47+day6!E47+day6!E47,
BUT in the sheet "totalDay" the columns from column1 to column5 I made rows - row1, row2, row3, row4, row5, only column6 I kept it as column.
In each sheet for each row an entry can be made in one of the columns form column1 to column5 and sometimes there may be a record in column6.
What I meen:
entry in column 2 and entry in column6,
entry in column 5 and entry in column6,
entry in column 3 and entry in column6,
entry in column 1 and entry in column6,
entry in column 5 and entry in column6,
So, in totalDay, where the columns form column1 to column5 are already rows (row1, row2, row3, row4, row5)
and only column6 is I kept it as column I need to cout:
row1 -> how meny entry there are in column6 for all days
row2 -> how meny entry there are in column6 for all days
row3 -> how meny entry there are in column6 for all days
I have a workbook with 8 sheets - day1, day2, day3, day4, day5, day6, day7 and totalDay.
In each sheet I have same table with 6 columns - column1, column2, column3, column4, column5, column6
Cell in each column is List with only one text. At the end of each column I have funcion to "=COUNTA" to count all filled cells.
Then the sum for each column and each day I save in totalDay with function =+day1!E47+day2!E47+day3!E47+day4!E47+day5!E47+day6!E47+day6!E47,
BUT in the sheet "totalDay" the columns from column1 to column5 I made rows - row1, row2, row3, row4, row5, only column6 I kept it as column.
In each sheet for each row an entry can be made in one of the columns form column1 to column5 and sometimes there may be a record in column6.
What I meen:
entry in column 2 and entry in column6,
entry in column 5 and entry in column6,
entry in column 3 and entry in column6,
entry in column 1 and entry in column6,
entry in column 5 and entry in column6,
So, in totalDay, where the columns form column1 to column5 are already rows (row1, row2, row3, row4, row5)
and only column6 is I kept it as column I need to cout:
row1 -> how meny entry there are in column6 for all days
row2 -> how meny entry there are in column6 for all days
row3 -> how meny entry there are in column6 for all days