How would I count specific cells in a column if they have a value other than zero or blank? The cells are scattered and not in consecutive order...like c6, c9, c11... No particular pattern.
I want to arrive at a total ( quantity) by counting just those cells that do not equal zero.
Thanks
Mike.
Do you mean?
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
COUNTA()
will count all non empty cells.
Is this what you need or you need count cells with TEXT only?
or
=COUNTIF($C$3:$C$15,"<>0")
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Or..
Formula:Please Login or Register to view this content.
Well, I couldn't get any of y'alls suggestions to work.
But this does work
=COUNTIF(B13,"<>0")+COUNTIF(B15,"<>0")+COUNTIF(B17,"<>0")
Note: The cells have a number, typically 0,1.5 or 2. Other cells in column B have values that are not related.
This formula sums up the count to give me a quantity needed for those parts which are identical in size. Sometimes, one or more of the cells will have 0 in them if they are not applicable to this project.
I would like the formula to be a little more elegant (simple) but just can't figure it out.
Your thoughts appreciated.
Thanks
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks