Results 1 to 3 of 3

Need a formula to count data

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2005
    Posts
    16

    Need a formula to count data

    I need some help. I am looking for a formula that will take data from one page and graph it on another page. The data I am trying to graph is arranged like so:

    A B

    1 q 2009.05.01
    2 w 2009.05.02
    3 w 2009.05.01
    4 q 2009.05.01

    I am looking for something that will look at column A and if the answer is "q" and then look at column B and if the answer is "2009.05.01" Excel will take that and count it in a specific cell on another page. In the case above, I want Excel to give me the answer of "2" in a designated cell.

    Can someone please help me.

    Thanks
    Last edited by VBA Noob; 05-02-2009 at 03:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1