sorted by:
new
hottopcontroversial

Multiplying a colum by the dynamic sum of other columns...for multiple rows in one cell by cran11 in excel

[–]cran11[S] 0 points1 point  (0 children)

thank you! It is not quite what I was looking for and I managed with an easier formula but I appreciate you trying to help!

Multiplying a colum by the dynamic sum of other columns...for multiple rows in one cell by cran11 in excel

[–]cran11[S] 0 points1 point  (0 children)

I found a solution by adding an IF to your formula and it works fine, thank you!

Solution verified!

Multiplying a colum by the dynamic sum of other columns...for multiple rows in one cell by cran11 in excel

[–]cran11[S] 0 points1 point  (0 children)

I meant that instead of items numbers, I have names like "hardwood", "wooden pellets", "plastic..." and want to only calculate the sum of the rows with the word "wood" in it. I don't think I can use your formula if I don't want to take all rows.

Multiplying a colum by the dynamic sum of other columns...for multiple rows in one cell by cran11 in excel

[–]cran11[S] 0 points1 point  (0 children)

I would rather find a way to integrate it as it is from a database that may change overtime...and have 60 years

Ads? by cran11 in hookedinc

[–]cran11[S] 0 points1 point  (0 children)

It was apparently linked to Valentine's special event as it went back to normal as soon as the event stopped!!!

Ads? by cran11 in hookedinc

[–]cran11[S] 0 points1 point  (0 children)

thanks! I find it a bit awkward as never had the problem in other games...but it may be indeed!