sumproduct

I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function to
count all the cells in the column that are not empty. How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

Would this help? You might be able to incorporate it into
your solution you are working on!
=COUNT(IF(P3:P1000=0,P3:P1000)) will count non blank
cells.
http://www.cpearson.com/excel/datetime.htm may also help
you.

-----Original Message-----
I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function to
count all the cells in the column that are not empty.
How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

.

I'm not sure how to incorporate the COUNTIF function into
the SUMPRODUCT function. What I want to do is count the
full cells (not empty) in one column, that correspond to
some criteria in a second and third column. For example:
Column A has dates, text and blanks in it.
Column B has initials of individuals.
Column C has yes's and no's.
I want to know how many entries there are for "PL" in
column B, with "yes" in column c, that are not empty in
column A.
A B C
Done PL Yes
7/4/03 MG Yes
8/9/03 PL No
PL Yes
5/8/03 MG No
In this case the count would turn out to be 2. Is there
some easier way to do this?
Thank you much,
Jennifer

-----Original Message-----
Would this help? You might be able to incorporate it into
your solution you are working on!
=COUNT(IF(P3:P1000=0,P3:P1000)) will count non blank
cells.
http://www.cpearson.com/excel/datetime.htm may also
help
you.

-----Original Message-----
I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function to
count all the cells in the column that are not empty.
How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

.

.

I meant the answer would be 1, because only the first row
has all the criteria. Sorry.
Jennifer

-----Original Message-----
I'm not sure how to incorporate the COUNTIF function into
the SUMPRODUCT function. What I want to do is count the
full cells (not empty) in one column, that correspond to
some criteria in a second and third column. For example:
Column A has dates, text and blanks in it.
Column B has initials of individuals.
Column C has yes's and no's.
I want to know how many entries there are for "PL" in
column B, with "yes" in column c, that are not empty in
column A.
A B C
Done PL Yes
7/4/03 MG Yes
8/9/03 PL No
PL Yes
5/8/03 MG No
In this case the count would turn out to be 2. Is there
some easier way to do this?
Thank you much,
Jennifer

-----Original Message-----
Would this help? You might be able to incorporate it
into
your solution you are working on!
=COUNT(IF(P3:P1000=0,P3:P1000)) will count non blank
cells.
http://www.cpearson.com/excel/datetime.htm may also
help
you.

-----Original Message-----
I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function
to
count all the cells in the column that are not empty.
How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

.

.

.

I figured it out. What I needed to enter was
......*('Main Log'!P3:P1000="")*...
Thank for the support!

-----Original Message-----
Would this help? You might be able to incorporate it into
your solution you are working on!
=COUNT(IF(P3:P1000=0,P3:P1000)) will count non blank
cells.
http://www.cpearson.com/excel/datetime.htm may also
help
you.

-----Original Message-----
I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function to
count all the cells in the column that are not empty.
How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

.

.

Try this...

SUMPRODUCT((A1:A50)*(B1:B5="pl")*(C1:C5="yes"))

-----Original Message-----
I'm not sure how to incorporate the COUNTIF function into
the SUMPRODUCT function. What I want to do is count the
full cells (not empty) in one column, that correspond to
some criteria in a second and third column. For example:
Column A has dates, text and blanks in it.
Column B has initials of individuals.
Column C has yes's and no's.
I want to know how many entries there are for "PL" in
column B, with "yes" in column c, that are not empty in
column A.
A B C
Done PL Yes
7/4/03 MG Yes
8/9/03 PL No
PL Yes
5/8/03 MG No
In this case the count would turn out to be 2. Is there
some easier way to do this?
Thank you much,
Jennifer

-----Original Message-----
Would this help? You might be able to incorporate it
into
your solution you are working on!
=COUNT(IF(P3:P1000=0,P3:P1000)) will count non blank
cells.
http://www.cpearson.com/excel/datetime.htm may also
help
you.

-----Original Message-----
I am using a SUMPRODUCT and one of my arguments is
.....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function
to
count all the cells in the column that are not empty.
How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer

.

.

.

There's no "not null" function in Excel. You are probably thinking of Access.

Use ""

On Wed, 24 Sep 2003 13:04:13 -0700, "Jennifer" wrote:

I am using a SUMPRODUCT and one of my arguments is
....*('Main Log'!P3:P1000=Not Null)*...
It is giving me an #NAME? error. I want the function to
count all the cells in the column that are not empty. How
do I do this? Also how do I get it to count only cells
with dates in them?
Thank you very much,
Jennifer