+ Reply to Thread
Results 1 to 4 of 4

Getting formula error contains error

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Getting formula error contains error

    Dear friends,
    I’m getting error in the formula below:

    =IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 B"),=(COUNTIF(i8:i100,">=7") + COUNTIF(i8:i100,"<7")),=(COUNTIF(j8:j100,">=7") + COUNTIF(j8:j100,"<7"))))
    If the cell on information sheet $b$1 contains ‘Std. 9 A or Std. 9 B’ then I want the formula for column ‘I’ else a formula for column ‘J’.

    Any help will be appreciated.

    Thanking you,
    Sincerely,

    mso3

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Getting formula error contains error

    Maybe this

    =IF(Information!$B$1="","",IF(OR(Information!B$1={"Std. 9 A","Std. 9 B"}),SUM(COUNTIF(I8:I100,">=7"),COUNTIF(I8:I100,"<7"),COUNTIF(J8:J100,">=7"),COUNTIF(J8:J100,"<7")),""))
    Last edited by AlKey; 08-25-2014 at 12:09 AM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: Getting formula error contains error

    You had extra "=" in front of the countifs
    try:
    =IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 B"),(COUNTIF(I8:I100,">=7") + COUNTIF(I8:I100,"<7")),(COUNTIF(J8:J100,">=7") + COUNTIF(J8:J100,"<7"))))
    Don't forget to ☆ me if I helped you!

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting formula error contains error

    Hi Alkey & Danerida,
    Thank you for solution.

    Alkey: The formula is doing the sum of column 'I & J' which I don't want. I want the sum of each column as per the condition on infomation sheet.

    Danerida: The formula is working fine with correct output of the sum of each column separately as per the condition.

    Thank you to both of you for assistance.

    Thanking you,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  2. [SOLVED] Inputbox error message. Formula you typed contains an error.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 02:25 PM
  3. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  4. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM
  5. Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM

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