| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers and non numbers(conditional values)
I can't seem to make a formula work that will count numbers greater than 3.7
as well as cells that contain the value <5 as below. 2 4 3.8 7 <5 1 2.3 = 4 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers and non numbers(conditional values)
=COUNTIF(A1:G1,""&3.7)+COUNTA(A1:G1)-COUNT(A1:G1)
-- Gary''s Student - gsnu200785 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers and non numbers(conditional values)
one simple way
=COUNTIF(D5:D11,3.7)+COUNTIF(D5:D11,"<5") d5:d11 is a sample, use your data range hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Ecoman" escreveu: I can't seem to make a formula work that will count numbers greater than 3.7 as well as cells that contain the value <5 as below. 2 4 3.8 7 <5 1 2.3 = 4 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers and non numbers(conditional values)
try this
=SUMPRODUCT(--(A1:G1<3.7)--(A1:G1="<5")) "Ecoman" wrote in message ... I can't seem to make a formula work that will count numbers greater than 3.7 as well as cells that contain the value <5 as below. 2 4 3.8 7 <5 1 2.3 = 4 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers and non numbers(conditional values)
It's close, but not quite there.
Here's the real data if it helps. 1.3 32 <0.5 6.4 15.7 12.8 58 50 <5 21 45 <5 34 13 <5 <5 <5 <5 <5 <5 <5 <5 <5 That should be 21 "Marcelo" wrote: one simple way =COUNTIF(D5:D11,3.7)+COUNTIF(D5:D11,"<5") d5:d11 is a sample, use your data range hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Ecoman" escreveu: I can't seem to make a formula work that will count numbers greater than 3.7 as well as cells that contain the value <5 as below. 2 4 3.8 7 <5 1 2.3 = 4 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers and non numbers(conditional values)
It works for some of the data, however I have values of <0.5 that get
included as part of this formula. Thank you for the quick response. "Gary''s Student" wrote: =COUNTIF(A1:G1,""&3.7)+COUNTA(A1:G1)-COUNT(A1:G1) -- Gary''s Student - gsnu200785 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
| can numbers be assigned to values, replacing values for numbers | Excel Discussion (Misc queries) | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| formula to count numbers of certain values | Excel Worksheet Functions | |||
Linear Mode
