Excell Help - Countifs

[rhysduck]

Hi,
Does anyone know why this formula is returning "#value" please?

=COUNTIFS(year,"7",type,"bullying*",roles,"victim")

It looks at various named ranges and return how many that match all of the criteria... so how many records are in the year group 7, with a "bullying" comment in the type name range and also "victim" in the roles name range.

it works fine with the first 2 criteria.

THanks.

 

[andshrew]

Is your roles named ranged definitely the same number of rows as the first two ranges?

 

[rhysduck]

Sorted it by using cell references instead of named ranges, works fine then

In answer to your question, yes. All named ranges are the same number of rows. A2:A1232 I think it was.