Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup assistance needed | Excel Worksheet Functions | |||
formula assistance needed | Excel Worksheet Functions | |||
Assistance needed with a formula | Excel Worksheet Functions | |||
CODE Assistance needed PLEASE please please | Excel Discussion (Misc queries) | |||
VBA Assistance Needed | Excel Discussion (Misc queries) |