Good morning,
In a table, I need to count the cells in two different columns, according to two conditions.
1. In a column of dates, it must be taken into consideration only the cells with the dates falling in a range, for example the cells with the dates between 01-01-07 and 01-02-07.
2. Considering the rows containing the cells found above, it must be counted only the cells that in a second column have values <= 0 (zero).
If I had only one condition, I would have been able to use the COUNTIF function.
For example, taking into consideration only the second condition:
=COUNTIF(R6:R116;"<=0")
I need to add the condition: O6:O116; "between 01-01-07 and 01-02-07"
Many thanks in advance for your the help.
Regards
Bookmarks