Hi,

This is my first post and was wondering if someone could help me.

I am trying to count the amount of times 2 conditions are met in Excel 2010. The first criteria is to look to see if a value appears in a named range in column C and the second is just to check if the value is equal to a cell in column G.

Is this at all possible I was trying;

=COUNTIFS('6-12 E'!$C:$C,Stream1,'0-6 E'!$G:$G,A4)
Stream1 being the named range containing 16 possible cells and A4 being the name of an employee.

I would be really grateful for some help.

Thanks,
Paul