Ar Bs Ec Ar Bs Ec
B A C B B

I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal to half an entry. I want to
count the total no of entries. So for the above the result would be 2.5.
Column 4 and 6 would be discounted because column 1 and 3 have a grade in
there.

Not sure how to start, would be grateful for help.

Thanks

Hi,
could you please provide an example, if the example is as per below, how do
you canount one entry for the first three columns ?

"mits" wrote:

Ar Bs Ec Ar Bs Ec
B A C B B

I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal to half an entry. I want to
count the total no of entries. So for the above the result would be 2.5.
Column 4 and 6 would be discounted because column 1 and 3 have a grade in
there.

Not sure how to start, would be grateful for help.

Thanks

i would do counta(a2:c2) which would give 2. BUt i then need it to not count
column 4 and 6 as column 1 and 3 have got data in there, but count column 5
as 1 and then divide by 2 to get half an entry.


"Eduardo" wrote:

Hi,
could you please provide an example, if the example is as per below, how do
you canount one entry for the first three columns ?

"mits" wrote:

Ar Bs Ec Ar Bs Ec
B A C B B

I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal to half an entry. I want to
count the total no of entries. So for the above the result would be 2.5.
Column 4 and 6 would be discounted because column 1 and 3 have a grade in
there.

Not sure how to start, would be grateful for help.

Thanks

How about this:

=COUNTA(A2:C2)+0.5*SUMPRODUCT(--(ISTEXT(D2:F2)),--(ISBLANK(A2:C2)))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mits" wrote:

i would do counta(a2:c2) which would give 2. BUt i then need it to not count
column 4 and 6 as column 1 and 3 have got data in there, but count column 5
as 1 and then divide by 2 to get half an entry.


"Eduardo" wrote:

Hi,
could you please provide an example, if the example is as per below, how do
you canount one entry for the first three columns ?

"mits" wrote:

Ar Bs Ec Ar Bs Ec
B A C B B

I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal to half an entry. I want to
count the total no of entries. So for the above the result would be 2.5.
Column 4 and 6 would be discounted because column 1 and 3 have a grade in
there.

Not sure how to start, would be grateful for help.

Thanks

thank you very much, i really appreciate it.

"Luke M" wrote:

How about this:

=COUNTA(A2:C2)+0.5*SUMPRODUCT(--(ISTEXT(D2:F2)),--(ISBLANK(A2:C2)))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mits" wrote:

i would do counta(a2:c2) which would give 2. BUt i then need it to not count
column 4 and 6 as column 1 and 3 have got data in there, but count column 5
as 1 and then divide by 2 to get half an entry.


"Eduardo" wrote:

Hi,
could you please provide an example, if the example is as per below, how do
you canount one entry for the first three columns ?

"mits" wrote:

Ar Bs Ec Ar Bs Ec
B A C B B

I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal to half an entry. I want to
count the total no of entries. So for the above the result would be 2.5.
Column 4 and 6 would be discounted because column 1 and 3 have a grade in
there.

Not sure how to start, would be grateful for help.

Thanks