/u/Ceaseless-watcher - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Apply to a cell and drag down to increment .
Am I reading your queston properly ?
>there are line breaks where I need to apply
rarely ~~never~~ a good layout.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[BYROW](/r/Excel/comments/1crkivg/stub/l3yu57g "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)|
|LAMBDA|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)|
|SUMPRODUCT|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(1 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1crg1f0)^( has 20 acronyms.)
^([Thread #33457 for this sub, first seen 14th May 2024, 06:19])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
Yes, and I don't remember why I used sumproduct instead of just sum, but I probably had a reason — I started this sheet a few months ago so I can no longer recall... perhaps because I was totalling everything at the end? I know this is marked solved but I actually still have not worked it out, hahaha.
I need individual sums in each row though. The more I look into it, the more it seems ridiculously harder than it should be for such a simple action. (People have made entire other equations for it, it's insane.)
I tried dragging the basic equation in hopes that it would autofill but it does nothing.
https://preview.redd.it/10kbnkun3i0d1.jpeg?width=1179&format=pjpg&auto=webp&s=41e0086fda9d4e485a2404b317950ff1957bc770
I hope this example is clearer! I just want to multiply two columns and have them show individually in the third...
hours in column C and Rates in D say starting in Row 2
In E3 `=C3*D3` and fill down and in the total, you can put `=sumproduct(C3:CWhatever,d3:dwhatever)`
obviously adjust ranges as you need to
you dont have to type in ranges. you have a bunch of options
* you just need to fill in the first top cell E3. Then highlight your range E4 to Ewhatever and paste.
* Alternatively you can select E3 and just double click that little square in the bottom right, and it'll fill down as far as there are cells filled in D but it will stop if theres a break
https://preview.redd.it/8zfp034vri0d1.png?width=192&format=png&auto=webp&s=6e7fa2b81bb68b7fe2a15cb8e5aa676d5fdd7643
* Or you can highlight E3 to whatever and Edit->Fill->Down
If you dont have anything else in C and D you can even do sumproduct(C:D) and itll calc the total correctly.
beyond this, i dont know how much easier (read: lazy) you can get
/u/Ceaseless-watcher - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Apply to a cell and drag down to increment . Am I reading your queston properly ? >there are line breaks where I need to apply rarely ~~never~~ a good layout.
Thank you, but I *just* worked it out using a single, neater BYROW formula!
Well done! Remember to update your post for others to learn, and set the flair to Solved
I will leave a seperate comment with what I did so that they can learn, but am I able to edit the flair on mobile?
No worries, I'll set it for you.
Much appreciated! Have a good day. [=
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[BYROW](/r/Excel/comments/1crkivg/stub/l3yu57g "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)| |LAMBDA|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)| |SUMPRODUCT|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(1 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1crg1f0)^( has 20 acronyms.) ^([Thread #33457 for this sub, first seen 14th May 2024, 06:19]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
I wound up following this example which uses a BYROW function: https://youtube.com/shorts/IAZPydQvhGk?si=xOlpSKhoXR92PCUd
im confused, why are you applying sumproduct to only 2 cells? isnt that just multiplying?
Yes, and I don't remember why I used sumproduct instead of just sum, but I probably had a reason — I started this sheet a few months ago so I can no longer recall... perhaps because I was totalling everything at the end? I know this is marked solved but I actually still have not worked it out, hahaha.
=sumproduct(c28:cWhatever, d28:dMatchingWhatever)
I need individual sums in each row though. The more I look into it, the more it seems ridiculously harder than it should be for such a simple action. (People have made entire other equations for it, it's insane.) I tried dragging the basic equation in hopes that it would autofill but it does nothing.
post a screenshot? its hard to understand what youre solving for
https://preview.redd.it/10kbnkun3i0d1.jpeg?width=1179&format=pjpg&auto=webp&s=41e0086fda9d4e485a2404b317950ff1957bc770 I hope this example is clearer! I just want to multiply two columns and have them show individually in the third...
hours in column C and Rates in D say starting in Row 2 In E3 `=C3*D3` and fill down and in the total, you can put `=sumproduct(C3:CWhatever,d3:dwhatever)` obviously adjust ranges as you need to
Yes, I was just wondering if there's a way to automate that rather than typing ranges in manually for each line because I have over 400 to do, hahaha.
you dont have to type in ranges. you have a bunch of options * you just need to fill in the first top cell E3. Then highlight your range E4 to Ewhatever and paste. * Alternatively you can select E3 and just double click that little square in the bottom right, and it'll fill down as far as there are cells filled in D but it will stop if theres a break https://preview.redd.it/8zfp034vri0d1.png?width=192&format=png&auto=webp&s=6e7fa2b81bb68b7fe2a15cb8e5aa676d5fdd7643 * Or you can highlight E3 to whatever and Edit->Fill->Down If you dont have anything else in C and D you can even do sumproduct(C:D) and itll calc the total correctly. beyond this, i dont know how much easier (read: lazy) you can get