Ask Your Question
0

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

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

_dave gravatar image

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

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

Comments

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 +0200 )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 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

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

pierre-yves samyn gravatar image

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

Hi

=SUMPRODUCT($B$3:$B$21=F$3;$C$3:$C$21=$E4)

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

[EDIT]

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.

Regards

edit flag offensive delete link more

Comments

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 +0200 )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 +0200 )edit
0

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

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

COUNTIFS

edit flag offensive delete link more

Comments

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 57 times

Last updated: Jan 28