Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of cells
I need to count the number of cells that indicate "utd" within a certain time
frame. ie; column E holds dates formated 1-12 column H holds data 'utd', 'in progress' or 'failed' I need to calculate how many 'utd' accounts within the month of '1' (Jan). I cannot seem to find a formula that will work for me...please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of cells
If you mean numerics 1 to 12 in column E try
=SUMPRODUCT((E1:E100=1)*(H1:H100="utd")) If ColE has got dates then try the below.. 012010 represent Jan2010 =SUMPRODUCT((TEXT(E1:E100,"mmyyyy")="012010")*(H1: H100="utd")) -- Jacob "Sabrina" wrote: I need to count the number of cells that indicate "utd" within a certain time frame. ie; column E holds dates formated 1-12 column H holds data 'utd', 'in progress' or 'failed' I need to calculate how many 'utd' accounts within the month of '1' (Jan). I cannot seem to find a formula that will work for me...please help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of cells
Here's one way: Create a helping column in, say, col Z, containing the
formula =E2&H2. Then use COUNTIF(Z:Z,"<monthutd"), where the <month can be "1utd", "2utd" etc. --- "Sabrina" wrote: I need to count the number of cells that indicate "utd" within a certain time frame. ie; column E holds dates formated 1-12 column H holds data 'utd', 'in progress' or 'failed' I need to calculate how many 'utd' accounts within the month of '1' (Jan). I cannot seem to find a formula that will work for me...please help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of cells
Hi JAcob thanks for giving me the formula but I still could not get it to
work...if i did if for each individual cell at a time it would work but i wanted it to be a selection of cells..thanks though "Jacob Skaria" wrote: If you mean numerics 1 to 12 in column E try =SUMPRODUCT((E1:E100=1)*(H1:H100="utd")) If ColE has got dates then try the below.. 012010 represent Jan2010 =SUMPRODUCT((TEXT(E1:E100,"mmyyyy")="012010")*(H1: H100="utd")) -- Jacob "Sabrina" wrote: I need to count the number of cells that indicate "utd" within a certain time frame. ie; column E holds dates formated 1-12 column H holds data 'utd', 'in progress' or 'failed' I need to calculate how many 'utd' accounts within the month of '1' (Jan). I cannot seem to find a formula that will work for me...please help |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of cells
HI Bob, thank you so much..it actually works!!!! yipee! You dont know how
long I have been trying to get this to work and it was so simple as your formula all along. A big Thank you to you!!! "Bob Bridges" wrote: Here's one way: Create a helping column in, say, col Z, containing the formula =E2&H2. Then use COUNTIF(Z:Z,"<monthutd"), where the <month can be "1utd", "2utd" etc. --- "Sabrina" wrote: I need to count the number of cells that indicate "utd" within a certain time frame. ie; column E holds dates formated 1-12 column H holds data 'utd', 'in progress' or 'failed' I need to calculate how many 'utd' accounts within the month of '1' (Jan). I cannot seem to find a formula that will work for me...please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of cells that match name AND number | Excel Worksheet Functions | |||
Counting the number of cells between 2 seperate cells | Excel Discussion (Misc queries) | |||
Counting the number of cells that have the same value | Excel Worksheet Functions | |||
Counting the number of same value cells | Excel Discussion (Misc queries) | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) |