Hi!
I want to sum up the quantity of product 1, 2, 3 and 4 with some kind of "Count.if" formula. The result should be, just as the attached file, the follwoing:
Product 1, 7
Product 2, 4
Product 3, 0
Product 4, 2
However, I want some kind of "Count.if" function, so that I can mark the whole B range, and count the occurences that each product type in column A.
For example:
B3 - 1, A3 - Product 1 –> Count 1 for "Product 1", and so on.
Thank you!
Use Pivot Table, Refer the attached file
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, formula version
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Could you put that into a sheet, please? I didn't quite understand you...
Hi, Ref the attachment
In F3 paste this formula; commit with Ctrl + Shift + Enter and fill down.
Formula:Please Login or Register to view this content.
Sheet attached.
Edit: forgot the count part; it's in F4 and filled down.
Last edited by FlameRetired; 11-07-2014 at 04:50 AM.
Thanks guys! The last method best meets my needs.
Hi, If your Query Solved, You can mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks