Home |
Search |
Today's Posts |
"&A1)&("<"&B1)), Microsoft Excel, newsgroup, help, assistance" /> "&A1)&("<"&B1)) Excel Discussion (Misc queries)" />
#1
|
|||
|
|||
Countif(table;(">"&A1)&("<"&B1))
This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1? tks |
#2
|
|||
|
|||
The simplest is
=countif(range,"<"&b1)-countif(range""&A1) "Micos3" wrote: This content works individualy, how can i make it work? is it any way to count the values between A1 and <B1? tks |
#3
|
|||
|
|||
Try...
=COUNTIF(Range,""&A1)-COUNTIF(Range,"="&B1) If your version of Excel uses the semi-colon as a separator, replace commas with semi-colons. Hope this helps! In article , Micos3 wrote: This content works individualy, how can i make it work? is it any way to count the values between A1 and <B1? tks |
#4
|
|||
|
|||
or
=sumproduct((a1:a22=a1)*(a1:a22<b1)) -- Don Guillett SalesAid Software "Micos3" wrote in message ... This content works individualy, how can i make it work? is it any way to count the values between A1 and <B1? tks |
#5
|
|||
|
|||
In my PC is only working this formula:
=sum((countif(table;"<"&B1))-(countif(table;"<"&A1)) but i don't know why in my friends PC isn't working, but i'll find out!!! thanks guys :) "Don Guillett" escreveu: or =sumproduct((a1:a22=a1)*(a1:a22<b1)) -- Don Guillett SalesAid Software "Micos3" wrote in message ... This content works individualy, how can i make it work? is it any way to count the values between A1 and <B1? tks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|