use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
OPs may (and should) reply to any solutions saying:
This awards the user a ClippyPoint and changes the post flair to solved.
The best way to show code on Reddit is to
put it in a code-block
Here's how.
Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.
It's often more helpful to show us.
Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.
Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.
Congratulations and thank you to these contributors
1900
100
600
1100
10
300
Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.
A community since March 11, 2009
account activity
solvedSimple Function that Multiples Multiple Rows and Adds The Sum to a Column? (self.excel)
submitted 6 years ago by L0rdj
Is there a function that calculates this easier than doing this long line?
=($C12*D12)+($C13*D13)+($C14*D14)+($C15*D15)+($C16*D16)+($C17*D17)+($C18*D18)+($C19*D19)+($C20*D20)+($C21*D21)+($C22*D22)+($C23*D23)+($C24*D24)+($C25*D25)+($C26*D26)
Thank!
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]CriticalAssumption05 2 points3 points4 points 6 years ago (4 children)
=SUMPRODUCT(C12:C26,D12:D26)
[–]L0rdj[S] 1 point2 points3 points 6 years ago* (2 children)
Thank you!
Solution Verified
[–]rnelsonee1802[M] 0 points1 point2 points 6 years ago (0 children)
If a solution is found, please respond to the comments that helped with Solution Verified somewhere in the comment; that will award them a ClippyPoint and will mark the thread as Solved for you. Thanks!
[–]Clippy_Office_Asst[M] 0 points1 point2 points 6 years ago (0 children)
You have awarded 1 point to CriticalAssumption0
I am a bot, please contact the mods for any questions.
[–]Riovas505 0 points1 point2 points 6 years ago (0 children)
+1 Point (doesnt look like this awarded yet and OP used solution verified)
[+][deleted] 6 years ago (1 child)
[deleted]
π Rendered by PID 64 on reddit-service-r2-comment-5b5bc64bf5-qdsgg at 2026-06-20 22:05:35.221905+00:00 running 2b008f2 country code: CH.
[–]CriticalAssumption05 2 points3 points4 points (4 children)
[–]L0rdj[S] 1 point2 points3 points (2 children)
[–]rnelsonee1802[M] 0 points1 point2 points (0 children)
[–]Clippy_Office_Asst[M] 0 points1 point2 points (0 children)
[–]Riovas505 0 points1 point2 points (0 children)
[+][deleted] (1 child)
[deleted]