count the number of values when two conditions are met

S

Sophie D.

Hi there,

I am struggling with an Excel Formula:

On one column I have the hotel contract status: Signed, cxl, in nego.
On the other column I have the location of the hotel: City Center, Airport,
Far away.

I want to calculate how many contract signed are in the city center, and I
have tried sumif, countif, but can't seem to get the proper result...


Help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum/group by 2 conditions 4
how to count a column based on condition of another column 4
Count if 2 criteria are met 1
sumproduct with 4 conditions 1
Two Condition - search 2
How to count a coloum if two conditions are met 5
Cell value when conditions are met 8
Conditional Arrays 1

Top