how to show correct values

N

natalie768

Hi, im new at this and not sure on how to explain what I need done, bu
Im trying to make a bowling league summary with my teams high series
high games, averages and games over. I was able to do the averages
and games over, but Im having trouble with high series, and high games
I want to get a number result not a total result. example: out o
these three games 175, 190, 255, I would like only the 255 to come bac
as an result not the number 3. can someone help me with this please.
there are 33 columns being used for each bowlers and there is only
bowlers. I wasn't sure if this is a what IF formula or countif.
=COUNTIF(G10:G42,">150") This is the formula I thought to use, but wa
wrong.
thank anyone for there input..

Natalie:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top