Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif Function with and Statement
I am trying to count the occourances in a row of data that are between $20 &
$25. Based on postings I have tried a couple of options...both are resulting in "0". =COUNTIF(F4:AK4,"and(F4:AK420,F4:AK4<25)") =SUMPRODUCT(--(F3:AK3="20"),--(F3:AK3="<25")) Any Ideas?? |