Hi all, im trying to get my spreadsheet to count in one cell if certain
criteria appear in two other cells, say for instance
=COUNTIF(Name,"Bloggs J" and Hours,= number) where hours is the next
named range and the number would be from -11 to 11.
So in short i would like the value for "Hours" displayed in Bloggs J
cell (which could be lets say E3) only if Bloggs J appears in the named
range "Name"
Hope that is clear and hope you can help!
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=401673