Ask Your Question

New question on how can I get the total count [Solved]

asked 2019-01-27 08:20:19 +0100

_dave gravatar image

updated 2019-01-27 13:35:20 +0100

I am going to revise my question with a new sample. What I am trying to do is to count the items based on their current status. I cannot seem to "see" on how to do this.Thanks ahead for any and all suggestions.

C:\fakepath\Item Total Count.ods

edit retag flag offensive close merge delete


PLEASE don't remove your questions! I have just lost my answer which I was typing while you removed your question. By the way, the Q&A site philosophy is not only get answers to own questions, but also help others who have similar questions; so it's rude to remove own questions with answers and discussion history, thus making answerers ' lives harder (context is lost), and other users won't see answers, too.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-27 08:24:37 +0100 )edit

I'm sorry about that. I knew there was an answer and not seeing any replies I decided to ask again in a different way. I'll just "add on" next time.

_dave gravatar image_dave ( 2019-01-27 13:26:23 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-01-27 08:31:00 +0100

pierre-yves samyn gravatar image

updated 2019-01-28 08:49:58 +0100



See item Total Count.ods

Note: the relative/absolute references allow you to enter the formula in F4 and then copy it by drag and drop


I'm really not sure I understood the new request, sorry if that's the case.... See item Total CountV2.ods

Maybe you should rethink the organization of your sheet to have columns that allow the use of a pivot table.


edit flag offensive delete link more


This is really good (for me). It allows me to add other products without having to change the formula. Thank you.

_dave gravatar image_dave ( 2019-01-27 13:40:38 +0100 )edit

Pierre-Yves, I have a question for you. Under parts, how could I change the formula if I just wanted the following: "Lock Pin","5mm shaft","LR Lock" and "Y-Rack Pin". In my real spreadsheet the number are really RMA numbers that are always changing. Thank you for your help.

_dave gravatar image_dave ( 2019-01-27 14:33:34 +0100 )edit

answered 2019-01-27 08:30:04 +0100

=COUNTIFS($B$3:$B$21;"234345 Lock Pin";$C$3:$C$21;"in repair")


edit flag offensive delete link more


Thank you for your solution, Pierre-Yves gives an answer which would allow me to add new product without having to edit each added product. It is good to see the different ways that leads to a very good learning curve.

_dave gravatar image_dave ( 2019-01-27 13:33:19 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-27 08:20:19 +0100

Seen: 52 times

Last updated: Jan 28