Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Quesion | Excel Discussion (Misc queries) | |||
hopefully a simple solution for Macro quesion | Excel Worksheet Functions | |||
Simple beginner question | Excel Programming | |||
Simple beginner question | Excel Programming | |||
Simple beginner question | Excel Programming |