+ Reply to Thread
Results 1 to 2 of 2

I need help setting up multiplication and Addition!

  1. #1
    Registered User
    Join Date
    Bolton, England
    MS-Off Ver
    Excel 2011 (mac)

    I need help setting up multiplication and Addition!

    As an infrequent user I cart remember how to set up the following:
    How do I multiply column E by Column F?
    How then do I add the resultant figures in rows 14 to 50?
    It's probably really simple but........

    If I then set it up as a template and have to add rows in future, how do I make sure thos rows "know" the right function of what I set up?

    Last edited by MikeJ1962; 02-17-2013 at 12:18 PM.

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    Radstock, Somerset
    MS-Off Ver

    Re: I need help setting up multiplication and Addition!

    Hi MikeJ1962

    E1*F1 copy down. Then use the SUM function to sum the required cells.

    Or the SUMPRODUCT, but not seeing a sample sheet it is hard to see what you require. perhaps upload a sample file.
    Regards Kevin

    Merged Cells (They are the work of the devil!!!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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