count the number of values when two conditions are met

  • Thread starter Thread starter Sophie D.
  • Start date Start date
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!!!
 
Back
Top