Sum of cells in column if data in cells = specific value

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

In column K, I have different information. Each cell either says "Returned"
or "Disposed."

In K35, I would like to have a total of all the cells in the column which
show "Returned" and in K36, I would like to have a total of all the cells in
the column whith show "Disposed"

Thanks
 
Hi,
Assuming that you are wanting to count the number of times
that Returned and Disposed in the range K1:K34 showup try"
in k35 put =countif(k1:k34,"=Returned")
in k36 put =countif(k1:k34,"=Disposed")

HTH
 
You must log in or register to reply here.

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

Similar Threads

Sum of cells if contain info 3
Numbers showing Up Centered in Cell ? 1
Cell not calculating after importing data 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
IF - how to avoid cells with no value 6
Summing 2 columns cells into a 3rd colums cells 1
How to determine the value within specific cell position? 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top