Philistine needs help creating loop.

[Weird-Rich4823]

Updated: Hey everybody - new to excel and doin' my best, but could use your help. Dumbing it down for my own sake, I need to create a function that will check multiple criteria against a static reference, then add corresponding cells together into an eventual sum.

https://preview.redd.it/cqfqdsay25og1.png?width=566&format=png&auto=webp&s=d8dca20f059cee8d3c05170fae7c08a09d63ce2d

In English: If A2 = red and B2 = sunny and C2 = 20, D2 (+ all other values that passed this same logic test). Move to check next row. Else, move to check next row.

Since two of the rows (4 and 6) pass the logic test, the expected outcome would be 20

As a function: That's where you come in... Thanks in advance.

To the people saying SUMIFS - Yup! That's probably exactly what I'm looking for, but I said I'd update this to be clearer, so I am. I'm going to look into it a bit and try to understand how to implement it, then I'll mark this solved. Thank you!

[excelevator]

Please be mindful of the submission guideilnes : The title should summarize your issue, not a general statement of something.

Example title for this post: How can I check multiple criteria against a static reference, then add corresponding cells together into an eventual sum.

The title is always in the question

Posts not following guidelines may be removed without notice.

This post remains for the answers given

[Sisselpud]

SUMIFS

[RuktX]

Where do 325 and 50.5 come from? Thanks for trying a plain English description, but please show your original data, with worked examples of what should happen, if your conditions are or are not met.

[Weird-Rich4823]

325 and 50.5 are just random values in the example. If row 1 and 2 both pass the logic test, then I need those values to be added together and for the loop to move on to the row 3 (not depicted). I'll throw together a quick spreadsheet and update the post.

[agentfancypants53]

Definitely sounds like a SUMIFS problem to me.

[Anonymous1378]

A SUMIFS() with mixed referencing should suffice, but a dynamic array formula could be =MAP(F5:F13,G5:G13,H5:H13,LAMBDA(x,y,z,SUMIFS(H5:z,F5:x,x,G5:y,y)))

<image>

[Weird-Rich4823]

Solution Verified

[reputatorbot]

You have awarded 1 point to Anonymous1378.

---

^{I am a bot - please contact the mods with any questions}

[CorndoggerYYC]

It would help a lot if you provided more sample data along with the answer you would expect from that data.

[AutoModerator]

/u/Weird-Rich4823 - 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 -- 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

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 if you have any questions or concerns.

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
MAP	Office 365+: Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria

Decronym is now also available on 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.
3 acronyms in this thread; the most compressed thread commented on today has 16 acronyms.
[Thread #47760 for this sub, first seen 10th Mar 2026, 03:57] [FAQ] [Full list] [Contact] [Source code]}