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

  • Thread starter That's Confidential
  • 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
 
M

mzehr

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
 

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

Cell data entering slow! 0
Excel does not accept text format! 0
Sum of cells if contain info 3
Cell not calculating after importing data 2
Consolidation Table from Different Excel Tabs with Different Format 1
Search cell value in same column 3
Getting Text data using the Data - Subtotal feature 1
List all tables, including document structure 0

Top