Results 1 to 5 of 5

Using countif to look at multiple sheets???

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2008
    Posts
    59

    Using countif to look at multiple sheets???

    I am trying to create a formula that will tell me how often our sales reps are going to specific accounts.

    I have a master list of each persons accounts and next to each account name there will be a cell with a formula in it. This formula will look at the cell next to it, "the account name", and then count how many times that name comes up over each months sheet. I was also wondering if I can then get the average over 12 months in the same formula. If not thats ok.

    The problem I am having is that I keep getting an error #VALUE!. I had no problem with it looking at only one sheet, but when I do more than one it gives me an error. I think it is the was I am breaking up each sheet. I have tried to do it every way I can think of... ,;) Nothing seems to work.

    Here is the formula that I am trying to use. What am I doing wrong?

    =COUNTIF(('Apr-08'!E7:E114):('May-08'!E7:E115):('Jun-08'!E7:E109):('Jul-08'!E7:E121):('Aug-08'!E7:E111):('Sep-08'!E7:E116):('Oct-08'!E7:E121):('Nov-08'!E7:E106):('Dec-08'!E7:E121):('Jan-09'!E7:E116):('Feb-09'!E7:E106):('Mar-09'!E7:E116),Customers!A20)
    Thanks for your help!
    Lukas
    Last edited by lukasj13; 10-08-2008 at 01:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count unique logs with multiple conditions of multiple sheets
    By Robert Bob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2007, 12:49 AM
  2. SUMPRODUCT across Multiple Sheets in the same workbook
    By Adrian17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2007, 01:41 PM
  3. Printing Multiple Sheets to One PDF file
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2007, 11:03 AM
  4. HELP NEEDED with COUNTIF in multiple sheets
    By Bob1955 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2006, 09:13 AM
  5. AAAaaahhhh Multiple Sheets Multiple Criteria
    By Hippychic in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2006, 11:32 AM

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