Excel Formulas - COUNTING PROBLEMS

A

arjcvg

Hi Guys!

I just want to know how will I do this in excel. For example I have th
following data:

DATE STATUS
8/1 done
8/1 done
8/1
8/1 done
8/1
8/1
8/1 done
8/2
8/2
8/2 done


Now, what I want to do is to count how many done status i have in
particular date. in this example for 8/1, i have 4 done status. and fo
8/2 i have 1 done status. How will I do this in excel?

Thanks
 
R

Ron Rosenfeld

Hi Guys!

I just want to know how will I do this in excel. For example I have the
following data:

DATE STATUS
8/1 done
8/1 done
8/1
8/1 done
8/1
8/1
8/1 done
8/2
8/2
8/2 done


Now, what I want to do is to count how many done status i have in a
particular date. in this example for 8/1, i have 4 done status. and for
8/2 i have 1 done status. How will I do this in excel?

Thanks!
Click to expand...

Here's one way:

With the date of concern in F3, use this formula:

=SUMPRODUCT((DATE=F3)*(STATUS="done"))

DATE is the named range containing your list of dates; STATUS is a named range
containing "done"'s or blanks.


--ron
 
S

Soo Cheon Jheong

Hi,

=SUMPRODUCT((A2:A1000=DATE(2004,8,1))*N(B2:B1000="done"))

--
Regards,
Soo Cheon Jheong
_ _
^ ^
v
 
A

arjcvg

Hi Guys!

How about this:


For example, I have the following data:
DATE---MENU---TIMEAVAILABLE
8/1-----Coke----5AM-2PM
8/1-----Spag----6AM-5PM
8/2-----Coke----8PM-9PM
8/2-----Spag----10AM-6PM

How can I print a report that looks like this:

MENU-------8/1-------------8/2
Coke--------5AM-2PM------8PM-9PM
SpaG--------6AM-5PM------10AM-6PM

Thanks a lot again for your help
 
Top