ExcelBanter - count the number of values when two conditions are met

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count the number of values when two conditions are met (https://www.excelbanter.com/excel-worksheet-functions/186816-count-number-values-when-two-conditions-met.html)

Sophie D.

count the number of values when two conditions are met

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!!!

Mike H

count the number of values when two conditions are met

Hi,

Try this

=SUMPRODUCT((A1:A20="Signed")*(B1:B20="City Center"))

Mike

"Sophie D." wrote:

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!!!

Sophie D.[_2_]

count the number of values when two conditions are met

AWSOME!!!

Mike you just saved the day!!!

Thanks soo much!!!

Mike H

count the number of values when two conditions are met

Your welcome and thanks for the feedback

Mike

"Sophie D." wrote:

AWSOME!!!

Mike you just saved the day!!!

Thanks soo much!!!

All times are GMT +1. The time now is 07:00 PM.