P
paulquinlan100
Hi
I need to fill a cell with a count of the number of rows that meet
certain criteria based on 2 columns.
e.g. i want to know the number of rows where Column1 > 01/01/2005 and
Column2 = "Site Dead"
Looking at previous posts i tried the following:
=SUMPRODUCT(--(Blackbook!BB3:BB1000>1/1/2005),--(Blackbook!
BM3:BM1000="Site Dead"))
However, i couldnt get this to work. I also tried using a Database
query which gave the correct result, but i need it to automatically
update when the data is altered.
Any ideas how i should go about this?
Thanks
Paul
I need to fill a cell with a count of the number of rows that meet
certain criteria based on 2 columns.
e.g. i want to know the number of rows where Column1 > 01/01/2005 and
Column2 = "Site Dead"
Looking at previous posts i tried the following:
=SUMPRODUCT(--(Blackbook!BB3:BB1000>1/1/2005),--(Blackbook!
BM3:BM1000="Site Dead"))
However, i couldnt get this to work. I also tried using a Database
query which gave the correct result, but i need it to automatically
update when the data is altered.
Any ideas how i should go about this?
Thanks
Paul