Ask Your Question
0

Conditional totals

asked 2019-07-29 09:57:31 +0200

Heskie gravatar image

I have a spreadsheet which totals prize money in our village flower show. Is it possible please to do a function which looks back along a row and counts up how many people got a score of exactly 100? Any ideas gratefully received!

edit retag flag offensive close merge delete

Comments

Also count how many 100 scores along a row any one person got (ignoring lower scores).

Heskie gravatar imageHeskie ( 2019-07-29 10:19:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-07-29 10:05:15 +0200

Use COUNTIF.

edit flag offensive delete link more

Comments

Thank you.

Heskie gravatar imageHeskie ( 2019-07-29 11:04:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-29 09:57:31 +0200

Seen: 36 times

Last updated: Jul 29 '19