If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
sumproduct
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 . |
#3
|
|||
|
|||
sumproduct
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 . . |
#4
|
|||
|
|||
sumproduct
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 . . . |
#5
|
|||
|
|||
sumproduct
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 . . |
#6
|
|||
|
|||
sumproduct
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 . . . |
#7
|
|||
|
|||
sumproduct
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 |
Thread Tools | |
Display Modes | |
|
|