| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do I compare occurances of countif of two values
How do I use Greater than and less than operators in conjuction with a
formatted cell using year 'yy' to count two particular ages age brakets the help formuala uses a - sign and this appears to subtract the two countif statement products |
|
#2
|
|||
|
|||
|
I guess you mean
=SUMPRODUCT(--(YEAR(A2:A100=2000)),--(YEAR(A2:A100<=2002))) assuming A2:A100 holds dates -- HTH Bob Phillips "Sea Jay" wrote in message ... How do I use Greater than and less than operators in conjuction with a formatted cell using year 'yy' to count two particular ages age brakets the help formuala uses a - sign and this appears to subtract the two countif statement products |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count occurances of years between two year brackets eg >24 & <50 | Excel Discussion (Misc queries) | |||
| Using COUNTIF & compare 2 different #'s | Excel Worksheet Functions | |||
| Allow clustered AND stacked bars on the same chart - compare valu. | Charts and Charting in Excel | |||
| Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
| Countif - Countif | Excel Worksheet Functions | |||
Hybrid Mode
