Forum Discussion
Solved
Calculating averages in a table, based on two criteria
I have a table with different type of values in columns, where the two first columns is a date and the day of the week, followed by several columns with different values (e.g. sales). I'm trying to ...
It is not allowed to enter ">" together with a cell reference.
Sure it is allowed. Lookup the many tutorials on the web.
Use ">"&A2.
I only get DIVISION/0 when using this. I need to enter a starting date and end date as a condition. However, I can't get it to accept a cell reference that should be higher/lower that a date specified in a cell outside the table. It is not allowed to enter ">" together with a cell reference.
It is not allowed to enter ">" together with a cell reference.
Sure it is allowed. Lookup the many tutorials on the web.
Use ">"&A2.