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

--
Message posted from http://www.ExcelForum.com

On Wed, 4 Aug 2004 17:51:15 -0500, arjcvg
wrote:

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!


---
Message posted from http://www.ExcelForum.com/

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

Hi,

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

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

:) Hi Guys!

Thanks for the reply! It worked! You're really a great help

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com