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
Bookmarks