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

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

At the moment i have the follwing in the cells, which is great and adds
1 for every instance it sees of the name in the Range "Name" but
instead of counting in column B each instance of the name and adding 1
i need it to see the name Bloggs J in the "name" range and then look
for the value on the same row in the range "Hours" this will then be
totalled with the results from another sheet as you can see in column
G.

Any thoughts?

Simon

COLUMN E

Bloggs J

COLUMN F
=COUNTIF(Name,"Bloggs J")

COLUMN G
=SUM(F40,'Holiday Count'!K33)


--
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

If you'd like to, email over a copy of your file at:
demechanik < at yahoo <dot com

Think a look at your set-up would be clearer

Drop me a note here if you're sending or not
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

will mail you but it won't be until 6pm GMT

Thanks,

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

No prob ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--