I am creating an inventory spreadsheet. I want to create a statement that if a cell equals a certain text then add a quantity of 1 to a cell that will equal the total of all that same product.InventoryMikrotik.xlsx
I am creating an inventory spreadsheet. I want to create a statement that if a cell equals a certain text then add a quantity of 1 to a cell that will equal the total of all that same product.InventoryMikrotik.xlsx
in which column you want to come 1
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Some where near the total column.
In my opinion the best tool for you would be the Pivot Table
As a general rule - in Excel the formula in a cell can change only this cell not other cells.
check it out the attached file and let me know
Okay thank you for your time.
The totals are totaling.
sorry for this, what exactly u want the output you want the total of a particular product which is RB450G
What I'd like is lets say i List RB450G or RB711, For every time I enter the text RB450G I want a total sum (the sum of every RB450G's I have listed) so lets say i have the text "RB450G" 3 times then I want a cell that has total quantity=3
i provide the same only to you see the attached file.
when ever u will enter the name total u will get at right side u can find out that sum of particular product name have a look
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks