View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Help with Counting.

I need some help with a Count, An example below. I need to count all the
lines that equal zero and where the aisle is between a-d. I will also need
one that adds in another feild of value class. So this one will get me the
total variance count per aisle but I will also nee dto know the variance per
value class and aisle. Thanks
Variance Aisle
-8 R
2 O
0 Q
0 L
0 J
-1 L
0 O
-38 J
10 K
4 O
0 O
0 L
-1 L
0 G
0 G
0 O
0 E