| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help, calculate dates and name in multiple columns
Can you figure out a MS Excel formula for me?
I want to calculate the total number of tests in our log referenced in three columns but under specific criteria. Ive searched MS help without success. I essentially want a formula that counts the data in columns C and D (cell filled with a date), only if the name €œDoe€ appears in column E. I understand that dates are referred as serial numbers by excel, but I still cant seem to figure it out. -- Tom B |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help, calculate dates and name in multiple columns
Look at the COUNTIF function.
Dave -- Brevity is the soul of wit. "TomB KY" wrote: Can you figure out a MS Excel formula for me? I want to calculate the total number of tests in our log referenced in three columns but under specific criteria. Ive searched MS help without success. I essentially want a formula that counts the data in columns C and D (cell filled with a date), only if the name €œDoe€ appears in column E. I understand that dates are referred as serial numbers by excel, but I still cant seem to figure it out. -- Tom B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
