S
Sentinel
I have a large spreadsheet (20+ columns and 2000+ rows) called 'big_list'.
On another spreadsheet, I use the following equation to display the number
of times the word 'Open' appears in column H.
=COUNTIF('C:\Spreadsheets\[big_list.xls]Sheet1'!$H$1:$H$1676,"Open")
Column B of 'big_list' contains dates. What equation would display the
number of times the word 'Open' appears in column H and have a date in
column B that is earlier than '25/10/03'. Any suggestions?
COUNTIF only seems to allow for one variable. Thanks in advance.
On another spreadsheet, I use the following equation to display the number
of times the word 'Open' appears in column H.
=COUNTIF('C:\Spreadsheets\[big_list.xls]Sheet1'!$H$1:$H$1676,"Open")
Column B of 'big_list' contains dates. What equation would display the
number of times the word 'Open' appears in column H and have a date in
column B that is earlier than '25/10/03'. Any suggestions?
COUNTIF only seems to allow for one variable. Thanks in advance.