Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function to show how often numbers within a range are pres
I use a sheet to track when I receive items, once per day, and I log the time
in 24 HR format using numbers, no formatting. I want to be able to count how many times in a row (Month) the number is between two numbers to help me identify if I get the items in morning, afternoon, evening. I think I would use countif but I don't know how to have it count each time the number in the cell is between the hours I determine. I think it would look like: countif(range,<1:1159) or something similar but I can't figure it out. Any help would be greatly appreciated! Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function to show how often numbers within a range are pres
=SUMPRODUCT(--(A2:Z2=--"08:00:00"),--(A2:Z2<=--"16:00:00")) as an example -- HTH Bob "joemc911" wrote in message ... I use a sheet to track when I receive items, once per day, and I log the time in 24 HR format using numbers, no formatting. I want to be able to count how many times in a row (Month) the number is between two numbers to help me identify if I get the items in morning, afternoon, evening. I think I would use countif but I don't know how to have it count each time the number in the cell is between the hours I determine. I think it would look like: countif(range,<1:1159) or something similar but I can't figure it out. Any help would be greatly appreciated! Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function to show how often numbers within a range are pres
I am pretty sure you can do a countif
you will need to put quotation marks around what you are looking for for the above I would use =COUNTIF(B:B,"11:59") hope this helps "joemc911" wrote: I use a sheet to track when I receive items, once per day, and I log the time in 24 HR format using numbers, no formatting. I want to be able to count how many times in a row (Month) the number is between two numbers to help me identify if I get the items in morning, afternoon, evening. I think I would use countif but I don't know how to have it count each time the number in the cell is between the hours I determine. I think it would look like: countif(range,<1:1159) or something similar but I can't figure it out. Any help would be greatly appreciated! Thanks in advance! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function to show how often numbers within a range are
Unfortunately it did not but thanks for trying! I continued to do some
searching for an answer and I found a formula that worked. Now my only problem is I have to research why it works but for now it does. I just don't know formulas that well yet and don't understand all the operands and statements used. This is the one I found that worked: (Copied from http://spreadsheetpage.com/index.php...ng_techniques/) To count the number of cells that contain a value between 1 and 10: =COUNTIF(data,"=1")-COUNTIF(data,"10") Once I edited for my data and cell ranges it worked perfectly! Thanks once again for the effort! I would bet I will be back for more help as time goes on and I try to learn more. "pmartglass" wrote: I am pretty sure you can do a countif you will need to put quotation marks around what you are looking for for the above I would use =COUNTIF(B:B,"11:59") hope this helps "joemc911" wrote: I use a sheet to track when I receive items, once per day, and I log the time in 24 HR format using numbers, no formatting. I want to be able to count how many times in a row (Month) the number is between two numbers to help me identify if I get the items in morning, afternoon, evening. I think I would use countif but I don't know how to have it count each time the number in the cell is between the hours I determine. I think it would look like: countif(range,<1:1159) or something similar but I can't figure it out. Any help would be greatly appreciated! Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif function for Even and Odd numbers | Excel Worksheet Functions | |||
can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
two numbers need to show each number in the range btw them | Excel Discussion (Misc queries) | |||
COUNTIF for range of numbers | Excel Discussion (Misc queries) | |||
Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions |