+ Reply to Thread
Results 1 to 2 of 2

What am I missing in my formula? (My formula is multiplying the answer by 33.)

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question What am I missing in my formula? (My formula is multiplying the answer by 33.)

    What am I missing in my formula? For some reason when cell I2=3, the total from cell BT38 is being multiplied 33 times. When cell I2=C, the answer is correct. (Adds up cells BS3 to BS35.)

    =SUMPRODUCT(('Teacher 1'!$I$2="C")*('Teacher 1'!$K$3:$K$35=3)*('Teacher 1'!$BS$3:$BS$35)+('Teacher 1'!$I$2=3)*('Teacher 1'!$BT$38))

    The way this formula is post to work is if cell "I2" has PK, K, 1, 2, 3, 4, 5, 6, 7 or 8, it will post the total from cell "BS38" and if cell "I2" has a "C", then it adds BS3 through BS35 that have a "3" in cell "K3" through "K35".

    In this link, the answer in G41 should be 1947, not 64251.
    http://i694.photobucket.com/albums/v...ps4b91c04c.jpg

    In this link, the answer in G41 is correct. It adds column from BS3 to BS35.
    http://i694.photobucket.com/albums/v...psf001cc1a.png

    * I did hide some rows and columns to make the pictures smaller.

    Here is the link to my sample spreadsheet
    Last edited by tivoman; 01-20-2014 at 11:25 PM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: What am I missing in my formula? (My formula is multiplying the answer by 33.)

    he way this formula is post to work is if cell "i2" has pk, k, 1, 2, 3, 4, 5, 6, 7 or 8, it will post the total from cell "bs38" and if cell "i2" has a "c", then it adds bs3 through bs35 that have a "3" in cell "k3" through "k35".
    =if(i2="c",sumif(k3:k35,3,bs3:bs35),"")

    ????
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. Replies: 1
    Last Post: 11-21-2012, 02:03 AM
  2. [SOLVED] Multiplying by 1 gives wrong answer.
    By Garren1013 in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 09:24 AM
  3. Multiplying B with C and answer in D column
    By sandyc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2008, 04:27 PM
  4. Creat a formula for multiplying a formula
    By Kylie Rose in forum Excel General
    Replies: 2
    Last Post: 01-19-2006, 01:25 PM
  5. [SOLVED] i edit a formula (excel) then it displays formula not answer
    By caiman in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 10: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