+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Excel frustration in Technical; I know ... windows forum ... but asking a general M$ app question ... I am getting a little frustrated ...
  1. #1

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,930
    Thank Post
    1,337
    Thanked 1,781 Times in 1,105 Posts
    Blog Entries
    19
    Rep Power
    594

    Excel frustration

    I know ... windows forum ... but asking a general M$ app question ...

    I am getting a little frustrated with Excel 2003.
    I am not exactly the worlds best user of excel, but sometime the necessary code for formulae just escapes me.

    The lasted is using countif.

    I know it is countif(range,criteria) but when I try and seperate a range it reports an error
    COUNTIF(D8+F8+H8+J8+K8+L8+M8+N8+O8+Q8+S8+T8+V8+X8+ Z8+AB8+AD8+AF8+AH8+AJ8+AL8+AN8+AP8+AQ8+AS8+AT8+AV8 +AW8+AX8+AY8+BA8+BB8+BC8+BD8+BF8+BG8+BH8+BI8,"=+") is not liked. However it is not every column that is needed and short of having another worksheet to pull the data in from (I am considering it) I am running short of ideas.

    If anyone can point me in the right direction it would be appreciated.

    Tony

  2. #2

    Join Date
    Jun 2005
    Location
    Elgin, Scotland
    Posts
    387
    Thank Post
    1
    Thanked 4 Times in 4 Posts
    Rep Power
    23

    Re: Excel frustration

    What you appear to be asking it is to Count a cell if it contains "=+". This will give an error, because you are trying to use a mathematical formula on two symbols. What is the actual criteria you are trying to count on?

  3. #3
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Re: Excel frustration

    Is the problem not that the 'D8+F8+...' is not a 'range'?

    You need to do something like this...

    = countif(D8, "=+") + countif(F8,"=+") + countif(H8,"=+")... etc.

  4. #4

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,930
    Thank Post
    1,337
    Thanked 1,781 Times in 1,105 Posts
    Blog Entries
    19
    Rep Power
    594

    Re: Excel frustration

    just had a similar answer on a NG ... I can't believe I missed that, even after trying =countif((D8,"=+")+(F8,"=+")) too ...

    I nearly had the right idea ...

    Thanks for the quick response.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  2. excel in explorer
    By Uraken in forum How do you do....it?
    Replies: 2
    Last Post: 18th October 2007, 02:07 PM
  3. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  5. Excel IF statement maybe VB
    By danIT in forum General Chat
    Replies: 1
    Last Post: 5th January 2007, 12:12 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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