 |
09-06-2016, 10:40 AM
|
#1 | ||
|
lolzcat
Join Date: Oct 2000
Location: Annapolis, Md
|
More Excel help sought - count of positive/negative values
I'm doing a fairly simple table. One calculated result yields a column of numbers, some positive and some negative.
I would like to include, at the bottom, a "count" of how many of those values are positive, and how many are negative. I strongly suspect there's a way to do this, but I'm stumped after flipping through the various formulas that I'm familiar with. Any help? |
||
|
|
|
09-06-2016, 10:44 AM
|
#2 |
|
College Starter
Join Date: Nov 2002
Location: La Mirada, CA
|
countif ?
|
|
|
|
|
09-06-2016, 10:45 AM
|
#3 | |
|
College Benchwarmer
Join Date: Oct 2000
Location: calgary, AB
|
Quote:
Yeah something like Countif(A1:A10,"<0") and Countif(A1:A10,">=0") |
|
|
|
|
|
09-06-2016, 10:46 AM
|
#4 |
|
Death Herald
Join Date: Nov 2000
Location: Le stelle la notte sono grandi e luminose nel cuore profondo del Texas
|
don't have the syntax in front of me, but it will be something like =COUNTIF(cell range,">0") for positive and "<0" for negative.
__________________
Thinkin' of a master plan 'Cuz ain't nuthin' but sweat inside my hand So I dig into my pocket, all my money is spent So I dig deeper but still comin' up with lint |
|
|
|
|
09-06-2016, 10:52 AM
|
#5 |
|
lolzcat
Join Date: Oct 2000
Location: Annapolis, Md
|
Yup, many thanks.
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
