Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a schedule that lists personnel as the row heading and dates as
the column headings that form a grid that lists the shifts the employ works on a particular date. The shifts are labeled "A", "B", etc. I need a formula (I'm guessing countif) that counts the number of times two employees work together. So, if "Bob" is the label for Row 1 and "Tom" is the label for Row 2, I need to know how many times they both have the same shift (A, B or C) in the same column during the month which is listed across 30 columns. I've tried several variations of countif to no avail. Thanks, mb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy/Cut Cells, Rows or Columns | Excel Discussion (Misc queries) | |||
copy cells from columns to rows | Excel Discussion (Misc queries) | |||
COUNTIF and AVERAGE only cells in unhidden rows | Excel Discussion (Misc queries) | |||
COUNTIF across Multiple Rows and Columns | Excel Worksheet Functions | |||
Countif in two columns and in different cells | Excel Discussion (Misc queries) |