countif help

[d0wnt0wn]

hi i currently have this formula that counts the number of times a cell in a range is above 0 and returns a value x 25...

=COUNTIF(BQ25:CM25,">0")*(25)



how do i set up the formula so i can check a different range but return the values from bq25 to cq25.....

if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25

Thanks

 

[Aladin Akyurek]

hi i currently have this formula that counts the number of times a cell in a range is above 0 and returns a value x 25...

=COUNTIF(BQ25:CM25,">0")*(25)



how do i set up the formula so i can check a different range but return the values from bq25 to cq25.....

if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25

Thanks

That "x" is hard to interpret in combination with "by"...

What do you mean by "count bq25:cq25" - that is, what is to be counted?

 

[Norie]

That "x" is hard to interpret in combination with "by"...

I think the OP means multiply by 25 with the 'x'.

 

[d0wnt0wn]

maybe it would be better to explain the problem that i am having....

i do stats for a pool league.. there are 24 teams in the league. we play 25 games on a league night. I need to count the total amount of games played so far in the season. this formula works fine:

=COUNTIF(BQ25:CM25,">0")*(25)


except for the odd occasion when a team gets a 0 out of 25 for a night....

what i have done in the past is add a +25 to the end of the formula manually. But I would like to have a formula do this for me somehow so if I ever stop doing the stats I can give someone else the workbook and they will not have to worry about this.

 

[d0wnt0wn]

also there is the odd occasion that a team has a bye or does not play that night for whatever reason

 

[anubis]

Hello d0wnt0wn.

When you say:

if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25

Do you mean that you want to count bq25:cq25 and multiply by 25 when the sum of bq30:cq30 is >0? If so then:

=IF(SUM(BQ30:CM30)>0,COUNTIF(BQ25:CM25,">0")*(25))

Or are you trying to match specific cells? ie If bq30>0, then multiply bq25 by 25 etc across the range.

Dave[/quote]

 

[Aladin Akyurek]

also there is the odd occasion that a team has a bye or does not play that night for whatever reason

You said:

"if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25"

Are the numbers in bq25:cq25 which must be counted, conditional upon bq30:cq30 being greater than 0?