count how many time a situation is true

[jsquirrel]

Hi

For the sheet im doing i need to preferable work this all out in one cell for ease as other people will be using the sheet.


This is what im trying to work out -


2.png
I Have how many times someone has been at a location on a new items release date but need to work out how many times they have been successful at making a sale to see there 'success rate'.

1.png
This is how it looks for the data im going off.
Is there a formula I could used that would out how many times has "Bob" been in a place and sold more than 1 item? With people being in so many different locations and locations needing to stay in order i cant work out a right combo of things to make it work it all out

Basically i if i know Bob has been in for the day a new item launches 4 times can a formula work out how many times they did well (eg. by eye can see sold more than one item 2 of the 3 times, 50% success rate)

Sorry if what ive written makes no sense but thank you for any help that can be given. Love excel and trying to learn to use it better but this one has me little lost.

[MrShorty]

Is there a formula I could used that would out how many times has "Bob" been in a place and sold more than 1 item?

In the end, it sounds like a COUNTIFS() function is what you want (unless someone decides it is better to use a pivot table). COUNTIFS() help file: https://support.microsoft.com/en-us/...rs=en-us&ad=us

The hardest part of putting the formula together -- assuming your picture is accurate as far as data layout -- is that your data layout is much less than optimum for a database type of operation. If this is a one off thing, then you can probably get away with using a sum of COUNTIFS(). If this is something you need to do frequently, I think you will better served in the long term to rearrange the data into a good database, then it will be easier to implement a COUNTIFS() function (or use a pivot table).