|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 6th, 2008, 02:56 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif criteria sg
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used =countif(B:B,"=12 and =29") but it did not work. =countif(B:B,"=12,=29") also did not work. what is the correct syntax for the criteria in the formula? thanks for your help fred 
|
|
#2
September 6th, 2008, 03:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
=COUNTIF(B:B,"30")-COUNTIF(B:B,"12")
-- Gary''s Student - gsnu200802
|
|
#3
September 6th, 2008, 03:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
try
=sumproduct((b2:b22=12)*(b2:b22=29)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Fred Loh" wrote in message ... i have a column (column B) of cells with numbers in the cells. i want to count for. example, how many cells have a number between 12 and 29. i used =countif(B:B,"=12 and =29") but it did not work. =countif(B:B,"=12,=29") also did not work. what is the correct syntax for the criteria in the formula? thanks for your help fred
|
|
#4
September 6th, 2008, 03:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
=SUM(COUNTIF(B:B,{"=12","29"})*{1,-1})
"Fred Loh" wrote: i have a column (column B) of cells with numbers in the cells. i want to count for. example, how many cells have a number between 12 and 29. i used =countif(B:B,"=12 and =29") but it did not work. =countif(B:B,"=12,=29") also did not work. what is the correct syntax for the criteria in the formula? thanks for your help fred
|
|
#5
September 7th, 2008, 03:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
thanks guys!
Gary's Student's solution works and the logic makes sense. Teethless mama's solution also works but I don't understand why the need to multiply {1,-1} i can't get Don's solution to work. i have a "#NUM!" error.
|
|
#6
September 7th, 2008, 03:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
Sumproduct does not take full columns. Must use a range as I did a2:a???
-- Don Guillett Microsoft MVP Excel SalesAid Software "Fred Loh" wrote in message ... thanks guys! Gary's Student's solution works and the logic makes sense. Teethless mama's solution also works but I don't understand why the need to multiply {1,-1} i can't get Don's solution to work. i have a "#NUM!" error.
|
|
#7
September 8th, 2008, 02:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif criteria sg
It works! Thanks Don.
"Don Guillett" wrote: Sumproduct does not take full columns. Must use a range as I did a2:a??? -- Don Guillett Microsoft MVP Excel SalesAid Software "Fred Loh" wrote in message ... thanks guys! Gary's Student's solution works and the logic makes sense. Teethless mama's solution also works but I don't understand why the need to multiply {1,-1} i can't get Don's solution to work. i have a "#NUM!" error.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
