LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Countif function

I have a table that looks like this:

DATE DOW Day 1 Day 2 Day 3

8/1/2008 Friday Camacho Trevino Rivera
8/2/2008 Saturday Camacho Trevino Zepeda
8/3/2008 Sunday Tenner Trevino Zepeda
8/4/2008 Monday Tenner Zepeda Zepeda
8/5/2008 Tuesday Tenner Camacho Camacho
8/6/2008 WednesdayTrevino Camacho Camacho
8/7/2008 Thursday Tenner Trevino Zepeda
8/8/2008 Friday Tenner Trevino Zepeda
8/9/2008 Saturday Tenner Trevino Zepeda
8/10/2008 Sunday Camacho Trevino Zepeda
8/11/2008 Monday Tenner Trevino Zepeda
8/12/2008 Tuesday Tenner Trevino Zepeda
8/13/2008 WednesdayCamacho Trevino Zepeda
8/14/2008 Thursday Tenner Trevino Zepeda
8/15/2008 Friday Tenner Trevino Zepeda
8/16/2008 Saturday Tenner Trevino Zepeda
8/17/2008 Sunday Tenner Trevino Zepeda
8/18/2008 Monday Trevino Camacho Camacho
8/19/2008 Tuesday Trevino Camacho Camacho
8/20/2008 WednesdayTrevino Camacho Camacho
8/21/2008 Thursday Trevino Camacho Camacho
8/22/2008 Friday Tenner Zepeda Zepeda
8/23/2008 Saturday Tenner Zepeda Zepeda
8/24/2008 Sunday Tenner Zepeda Zepeda
8/25/2008 Monday Tenner Zepeda Zepeda
8/26/2008 Tuesday Tenner Zepeda Zepeda
8/27/2008 WednesdayTenner Zepeda Zepeda
8/28/2008 Thursday Tenner Zepeda Zepeda
8/29/2008 Friday Rivera Camacho Tenner
8/30/2008 Saturday Camacho Rivera Trevino
8/31/2008 Sunday Camacho Rivera Trevino

I want formulas that will populate the "?" marks (see below) with counts as
to the total number of times each person's name appears within each column
range for Day 1, Day 2, and Day 3:

Camacho Rivera Tenner Trevino Zepeda
Day 1 ? ? ? ? ?

Day 2 ? ? ? ? ?

Day 3 ? ? ? ? ?

Thanks in advance for your suggestions.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with countif function Gareth Wretham Excel Worksheet Functions 3 September 25th 07 11:11 PM
please help how to combine IF function with Countif function Dinesh Excel Worksheet Functions 6 March 30th 06 08:28 PM
How do I use a countif function according to two other countif fu. Kirsty Excel Worksheet Functions 2 February 20th 06 11:44 AM
Embed a countif function in subtotal function? Stuck at work Excel Worksheet Functions 1 February 14th 06 03:19 AM
countif function nwilson Excel Worksheet Functions 2 November 3rd 05 02:46 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"