Countifs - Not returning correct value

[bekyleigh]

Hello,

So I'm building a tracker for draught units in the UK, i want to have an overview tab which counts how many venues each pub group has listed if the venue is pouring.

I need to be able to count X amount of venues with 2 x criteria.

The formula i have used is as follows:

=COUNTIFS('Draught Log'!$B$2:$B$100,"Molson Coors", 'Draught Log'!$C$2:$C$100,"Pouring") - From the tab 'Draught Log' I need to count how many times column B= "Molson Coors", and Column C="Pouring" - This formula keeps returning "0" which i know is incorrect.

Help please Should i be using countif for this calculation?

 

[Fluff]

Check that your values in B & C do not have any leading/trailing spaces.

 

[bekyleigh]

Hi,

There was! All fixed now, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.