Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've been playing with coordinate data and want to be able to make a box somewhere in the middle of the spread of data. I was hoping that someone could confirm this formula:
=(countif(A1:A10,"=-1")-countif(A1:A10,"1"))+(countif(B1:B10,"=-1")-countif(B1:B10,"1")) Am I going about this all wrong? The answers spit out seem reasonable, but I haven't found anything on this topic on the web. Thank you for any help that can be provided. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
another COUNTIF question | Excel Worksheet Functions | |||
Countif question how do I do this ? | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
CountIf Question | Excel Worksheet Functions | |||
countif question | Excel Worksheet Functions |