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
|