Here is the formula I am using on the worksheet I currently have all my data stored on.
=SUM((K3:K5999=K6)*(N3:N5999>VALUE(1/1/1990)))
The information I am working with are referral programs and I want to see which referral programs also have a 'start' date. I would like to summarize all this data on a separate tab by Number of referral sources who have a start date.
The problem I am having is when I try to enter this formula from the summary tab. I have heard of using INDIRECT to solve this problem but have failed many times. When I enter the above formula (with coressponding names of the first tab with all my data) it gives me 'VALUE' errors.
Can anyone help me?
THANKS!
=SUM((K3:K5999=K6)*(N3:N5999>VALUE(1/1/1990)))
The information I am working with are referral programs and I want to see which referral programs also have a 'start' date. I would like to summarize all this data on a separate tab by Number of referral sources who have a start date.
The problem I am having is when I try to enter this formula from the summary tab. I have heard of using INDIRECT to solve this problem but have failed many times. When I enter the above formula (with coressponding names of the first tab with all my data) it gives me 'VALUE' errors.
Can anyone help me?
THANKS!