nested array

Hello All! Trying to solve the following: A purchase order is placed for a product on DATE A. (For purposes of demonstration, let's say July 1, 2022) The product has a Part Number (which can be numeric or text) within a contract number (text) within a supplier number (text) Prices for each...

Hello, I've spent quite a while trying to work out how to use sum product with a look up nested inside it. I'm trying to calculate the annual sum of payments received by a group. People in the group receive payments either weekly or monthly. I receive a regular report which contains: how...

Hi, I have a list of terms (list a) and a list of the states (list b) and I want to write a formula that counts when one of the values in list a contains one of the values from list b Example <tbody> list a list b cars to buy in florida florida florida places to buy cars new york new...

I am looking for a single formula that will aggregate data for a parent group with a one to many relationship. Imagine I have sales by employee and I have an employee to group mapping table. My goal is to create a table with sales by group without mapping the group to the sales by employee...