put this a cell to the right of your table:(you first have to remove all
spaces from your table-steve and sunday had spaces at the end, which I
removed; also make sure you've got things spelled right)

=SUMPRODUCT(--($A$2:$A$6="Sunday"),--($B$2:$B$6="Steve"))

hth,
Dave
"danham" wrote:

If anyone could help me with this one. I can't figure it out.

Example of table (it's a working schedual):

a b c d
Day DayShift NightShift
1 Monday John Mary
2 Tuesday Steve Jack
3 Wensday Ivone Mark
....
7 Sunday Steve Mark

*this table goes like this for hole month

Problem:
I would like to count how many "sundays" in "DayShift" did employee in
example "Steve" worked this month. I figured to use COUNTIF when I
needed to count how many "DayShifts" Steve worked
(CountIf(C1:C7;"Steve"), but that included range of only one column -
even that was realy big thing for me :). But now I need to count for
"Steve" in "Dayshift" only if it's "Sunday". I just can't find the
proper function. My english is not too good, so I hope you understand
what I'm trying to say.

THANK YOU!!!