Hi Excel Wizards,
I want to count how many sales we have made from different prices. E.g. in the attached spreadsheet, it shows that 1 sale is made by $20 and 2 sales are made by $40.
However, how to use the formula to pick up the sales $amount without duplicate them (red colored)?
Thanks
Hello and welcome to the forum,
I'm sorry but I don't even understand what you mean. Can you work out an example or two for us? Obviously you know Countif, so what are you after Sumif? I'm not sure exactly from your brief description.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi
Column A is the sales we have made, in that example, there are 15 sales in total with different prices (e.g. $100, $200).
What I want is how to use the formula to tell us, in column A, we have sales for 1@$20, 2@$40, 3@100 etc.
Thanks
How about this with a pivot table.
Last edited by jeffreybrown; 07-09-2012 at 09:32 PM. Reason: New attachment
HTH
Regards, Jeff
Awesome,
I was stuck in the formula and didn't think of the pivot table. Thank you very much Jeff
You are most welcome. Just remember on a PT, if you update your data the PT does not automatically update; rather, right click on the PT on refresh.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hi kleevin,
To expand on Jeff's answer. You can also get the total of sales along with counts. See attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Brilliant, that would impress my boss more, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks