excel help: Anyone good with excel worksheets? - Help.com

Anyone good with excel worksheets?

I’m trying to figure out a way to make a formula that will work so I don’t have to work so hard… See I need a formula that will change by row but not column… I’ve got two columns with different numbers and I need the rows to be multiplied together individually, e.g. h1 * j1, h2*j2, h3*j3 etc… but if I have to put them all in individually it will take hours… any ideas?

This open post was written 3 weeks, 4 days ago | V/U/S: 56, 4, 3 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post jh14591 may have helped people, but has not within the last 4 days. jh14591 is a verified member, has been around for 9 months, 1 week and has 17 posts and 188 replies to their name.

Post Tags (3)

excel, spreadsheets, formulas (How Tags Affect Reciprocity)

Replies (4)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

SexySteph89 offline Verified User (1 month) Shouts: 17 #
An Unknown Location | 3 weeks, 4 days ago (9 minutes after post)

Why dont you just do the j1*h1 formula in the first box then when the answer is put into the box put your mouse on the bottom right hand corner of the box and drag the formual down. It should fill in the formuala for the rest and give the answer.

Quote this reply Report this reply to moderators
Help me with: Cops.
jh14591 offline Verified User (9 months, 1 week) Long Term User Shouts: 3 #
An Unknown Location | 3 weeks, 4 days ago (15 minutes after post)

omg you are so wonderful thank you so much… I’m still new to excel.

Quote this reply Report this reply to moderators
Help me with: So…
SexySteph89 offline Verified User (1 month) Shouts: 17 #
An Unknown Location | 3 weeks, 4 days ago (16 minutes after post)

No problem…Once you learn the little trick it will be SO much easier. Good Luck!

Quote this reply Report this reply to moderators
Help me with: Cops.
scjarv offline Verified User (3 months, 4 weeks) Long Term User Shouts: 0 #
An Unknown Location | 3 weeks, 4 days ago (18 minutes after post)

Yes. You can just copy and paste the first formula. Each new row will add to both columns. Put in the first one, copy it, and then paste it down the column as far as you want to go.

Quote this reply Report this reply to moderators

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.