Assistance Needed in Performing Count of different types- Simple SQL, not VBL
I'm trying to perform a sum of the number of incidents in
a certain range of mileposts. I have all the MP in one
column, and have simplified them down to half mile
increments (i.e. 215, 215.5, etc.) using a statement that
said =CEILING(C15705,0.5). I then wrote a statement that
said =IF(AD15705<AD15706,COUNT($AD$15705:AD15705),"").
What I want it to do is to start the count over for each
different MP section (215-215.5 and then another count for
215.5-216 for example).
Is there a way to do this? Helpful e-mails may be directed
to my e-mail account.
Thanks,
Christina
|