Results 1 to 2 of 2

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

Threaded View

tivoman What am I missing in my... 01-20-2014, 10:08 PM
vlady Re: What am I missing in my... 01-20-2014, 11:35 PM
  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.

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. [SOLVED] 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. 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