| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with various type
I have four cells that contain
number, text, date, #n/a How can i count all four cells using counta but date only will be counted if less than criteria that i've made <example : less than today() Thx a lot, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count with various type
Try
=COUNTA(H13:H16)-COUNTIF(H13:H16,"=" & TODAY()) If this post helps click Yes --------------- Jacob Skaria "Pran" wrote: I have four cells that contain number, text, date, #n/a How can i count all four cells using counta but date only will be counted if less than criteria that i've made <example : less than today() Thx a lot, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count with various type
Thx again Jacob,
I appreciate that "Jacob Skaria" wrote: Try =COUNTA(H13:H16)-COUNTIF(H13:H16,"=" & TODAY()) If this post helps click Yes --------------- Jacob Skaria "Pran" wrote: I have four cells that contain number, text, date, #n/a How can i count all four cells using counta but date only will be counted if less than criteria that i've made <example : less than today() Thx a lot, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count more than one type of value from the same column | Excel Discussion (Misc queries) | |||
| count of different type records | Excel Worksheet Functions | |||
| Count between dates by type | Excel Worksheet Functions | |||
| How do I ask Excel to count how many items are in BOLD TYPE? | Excel Discussion (Misc queries) | |||
| Is there a WorkDay() type function that count all days except tho. | Excel Worksheet Functions | |||
Linear Mode
