Results 1 to 3 of 3

Thread: Long multiplication with fixed cell

  1. #1

    Long multiplication with fixed cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    There has to be a better formula than the one below. It leaves too many opportunities to enter an incorrect cell and can be long when you have a lot of columns. Any help would be greatly appreciated.

    =sum($d$4*d6)+($e$4*e6)+($f$4*f6)...... I'm trying to multiply and add up columns across the spreadsheet.

    Scott

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try SUMPRODUCT()

    e.g.

    =SUMPRODUCT($D$4:$F$4,D6:F6)


  3. #3
    Quote Originally Posted by NBVC View Post
    Try SUMPRODUCT()

    e.g.

    =SUMPRODUCT($D$4:$F$4,D6:F6)
    That worked perfectly! Thanks!

Posting Permissions

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