Question:

Excel counting question. How do I count the number of times a value (the result of formula) appears in a list?

by  |  earlier

0 LIKES UnLike

Excel counting question. How do I count the number of times a value (the result of formula) appears in a list?

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. use the COUNTIF() formula.  the basic syntax is countif (range to check, criteria to look for).

    so if you list is in A1...A50 and your criteria is to find how many times "10" appears do:

    =COUNTIF(A1:A50, 10)

You're reading: Excel counting question. How do I count the number of times a value (the result of formula) appears in a list?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now
Unanswered Questions