If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total dates e!
Column A is Names! I would like to have Dates Missed in
column B and the total number of all these days in a cell in Column C. Can you assist? Name DateMissed Totalnumberofdays missed |
#2
|
|||
|
|||
Total dates e!
=COUNT(B1:B1000)
-- Regards, Peo Sjoblom "Gazabou" wrote in message ... Column A is Names! I would like to have Dates Missed in column B and the total number of all these days in a cell in Column C. Can you assist? Name DateMissed Totalnumberofdays missed |
#3
|
|||
|
|||
Total dates e!
IN A1 type Names
In B1 type Datesmissed In C1 type Totalnumberofdaysmissed In C2 type the formula =COUNT(B:B) Then highlight all three columns and do Format Column Auto fit selection.............this will set the width of all three columns to encompass the text you just typed in Row 1. Then enter your names in column A and the corresponding dates missed in column B (but only one date per row), as you described and the total number of dates missed will accumulate in cell C2 Vaya con Dios, Chuck, CABGx3 "Gazabou" wrote in message ... Column A is Names! I would like to have Dates Missed in column B and the total number of all these days in a cell in Column C. Can you assist? Name DateMissed Totalnumberofdays missed |
Thread Tools | |
Display Modes | |
|
|