# countif help

#### d0wnt0wn

##### Well-known Member
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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
d0wnt0wn said:
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?

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

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

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.

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

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]

d0wnt0wn said:
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?

Replies
3
Views
164
Replies
14
Views
1K
Replies
3
Views
493
Replies
3
Views
157
Replies
4
Views
572

1,203,524
Messages
6,055,905
Members
444,832
Latest member
bgunnett8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back