Results 1 to 3 of 3

Formula to multifly 2 cells for 400 rows

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to multifly 2 cells for 400 rows

    Hello:

    Please refer to attached file.

    I need a formula in Cell P2,T2,X2, (every 4th column) to do the following:

    P2= (P6*$F6)+(P7*$F7)+..........................(P398*$F398)

    Either a formula or VB code would work for me.

    Let me Know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need a formula for identifying text in rows of cells
    By steve08087 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2013, 01:45 AM
  2. [SOLVED] Formula to use to subtract 2 cells in a row and put the same formula for over 1000 rows
    By milk1one in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2012, 12:08 AM
  3. [SOLVED] Formula for moving rows of cells??
    By KeirL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2012, 04:45 PM
  4. Replies: 5
    Last Post: 06-01-2011, 02:06 PM
  5. Replies: 3
    Last Post: 02-15-2006, 09:25 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