Countifs function returns VALUE

[LiseGKristensen]

Hi,

I'm trying to count the number of times a given name in a column has a value of >0. However it gives me "=VALUE!".. 

This is my function: =COUNTIFS(B2:B14;B2;C2:E14;">0")

I am using number format for the number column and general format in the text column. 

I can't get it to work in both excel web version and on the desktop.

I have tried to follow the "work around" suggestions from microsoft on their post about this problem, but it seems that is does not suit the CountIFS but only CountIF.

Thank you :) 

[#2 · Accepted solution]

=COUNTIFS(B2:B14,B2,C2:C14,">0")