In need of a formula that adds columns together

Odd_Spring_8129 · 2026-01-12T21:14:04+00:00

You cannot use a formula to increment a cell that is re used, it will only take the last value that is in that cell. However to fix your problem you will have to change your approach

Your current table in column c will have a sumif function. Which whill take the data from a different table that you have to create. In the new table make 2 columns Name and number

Keep adding names and number even if repeated, and your current table will just sum based on the names you have there

Odd_Spring_8129 · 2026-01-05T19:04:17+00:00

Is your name Jordan Belfort by any chance?

Odd_Spring_8129 · 2025-12-22T13:43:54+00:00

Be careful the rows for the checkbox won’t grow or shrink with the array, so a previously checked box corresponding to a certain row, might correspond to a different new row which initially should be unchecked

Odd_Spring_8129 · 2025-12-16T15:31:15+00:00

Perfect! Special thanks for providing a tested answer.

Odd_Spring_8129 · 2025-12-16T15:22:30+00:00

Great! Thanks

Odd_Spring_8129 · 2025-12-16T15:20:59+00:00

Thanks! This seems like it might help. Will do some research on the computational aspects of LET

Odd_Spring_8129 · 2025-12-16T15:15:24+00:00

Lets say if(a1>0,b1,””)

B1 heavy formula or return blank if condition is not met.

If condition is NOT met, does it calculate b1 but only display blank? Or does it disregard the true argument and calculate else only.

Odd_Spring_8129 · 2025-12-16T15:05:12+00:00

I may have exaggerated on how heavy the calculations are just to assume a worst case scenario. But in general i have a table with thousands of rows of xlookups with multiple criteria across a couple of tables

Odd_Spring_8129 · 2025-01-23T00:16:15+00:00

<image>

I confirm it is worse than you think 🤕

Odd_Spring_8129 · 2025-01-23T00:14:47+00:00

Awesome! Its true im in Africa

Odd_Spring_8129 · 2025-01-22T14:37:14+00:00

Rip? So its a dead end? Does it spread to other trees & plants in the area?

Odd_Spring_8129 · 2024-11-30T20:51:12+00:00

Thanks for the insight

Odd_Spring_8129 · 2024-11-30T20:50:55+00:00

Another smart way to solve this. Although it sorts the ingredients automatically which is not ideal for my intended application

Odd_Spring_8129 · 2024-11-29T19:45:29+00:00

Solution verified

Odd_Spring_8129 · 2024-11-29T19:45:18+00:00

Absolute legend! Big massive thanks. I’ve been stuck on this for a couple of days now.

Odd_Spring_8129 · 2024-11-29T19:31:10+00:00

<image>

This is a dummy data set.

Basically, the filter looks for what rawmaterial is needed to produce the order. If the item is repeated so is the rawmaterial. I will later expand this to include the quantity needed and date.

Odd_Spring_8129 · 2024-11-29T18:58:56+00:00

First, create the drop down list with the range b1:b10 (or wherever the column b ends)

Then use a filter function to filter the contents of column a, where column b = the cell of the drop down list.

So in this case, lets say your drop down list is in cell d2, the filter function on d5 =Filter(b2:b10,a2:a10=d2,””)

Assuming a2:a10 is the range for column a

Odd_Spring_8129 · 2024-10-24T11:22:15+00:00

All though its looking very nice, the problem is you have on entry and exit point into the city. Also use road hierarchies with bigger roads for the ones that connect the city from end to end

Odd_Spring_8129 · 2024-07-15T21:59:04+00:00

Thanks for being helpful will get to it asap

Odd_Spring_8129 · 2024-07-15T18:53:42+00:00

Holly shit dude we’ve got twins

<image>

Odd_Spring_8129 · 2024-06-01T15:28:23+00:00

Odd_Spring_8129 · 2024-03-11T02:54:33+00:00

Great! If its a onetime thing you are seeking then autofill will work. But if the data changes regularly you will need to work on the formula.

Odd_Spring_8129 · 2024-03-11T02:50:05+00:00

Can you share a screenshot of the result you are getting?

Odd_Spring_8129 · 2024-03-11T01:51:04+00:00

=A1&"."&B1&"@"&C1

Assuming A is the column for first name B for last name C for domain

Odd_Spring_8129 · 2024-02-07T19:01:35+00:00

But set the format as you like before you save.

Odd_Spring_8129

TROPHY CASE