Maybe you mean in E3:
=SUMPRODUCT((Name="Bloggs J")*(Hours=10))
which would return the count you're after in your line
=COUNTIF(Name,"Bloggs J" and Hours,= number)
assuming the "Hours" number = 10
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Simon Lloyd"
wrote in message
...
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