ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
20192018201720162015
2
$0.00$4,341.00$0.00$5,281.00
3
4
$10,805.00$2,865.00$8,295.00
5
00$233.00
6
SUMS$0.00$0.00$15,146.00$2,865.00$13,809.00
7
8
KEWL!
9
2019#VALUE!
10
2018$0.00
11
2017$4,341.00$10,805.000
12
2016$0.00$2,865.000
13
2015$5,281.00$8,295.00$233.00
14
15
16
17
hi
18
19
hello
https://stackoverflow.com/a/58175677/5632629
20
21
Thank you much! I guess that formula was on the right track. I just don't have any experience with MMULT. Might as well be japanese
22
What does adding "ROW" do?
np
23
24
25
$1.00
<< just column of ones
26
$1.00
27
$1.00
hmm. I'll have to mess around with it
28
$1.00
29
30
31
could be:$0.00015146286513809
32
Do the ones just give the MMULT a value?
MMULT logic:
33
So it doesn't "break"
kinda yeah
34
basicaly mmult works like this:
35
3 x 3
36
37
1 row * 1 column
38
thats why one of it needs to be transposed coz normaly you dont store your dataset in such way
39
I think I understand
40
Not sure how it went from multiplication to addition, but whatever. lol
41
42
by having ^0 it became addition
43
44
ohhhhhhh
45
I was trying to lookup what the ^ did the other day and found absolutely ZILCH
46
47
48
42x2
49
273x3x3ok
50
82x2x22x2...?
smh. of course. ok
its called "power"
51
:)
BUT, that's all still MULT
52
201
Or is it like a double negative
nah, no negative
53
101yes
So it just takes whatever number and changes it to 1 basically?
54
mmult translated lol
(20*1)+(10*1)=30
1
55
np
lol thank you! this has all been very helpful
grrrr
56
its good to know stuff :D
Usually, I just accept the answer and sleep easy knowing it's just working. By I had to know how this one works
57
Agreed! Knowing stuff is good
58
Well, thank you again! I know you have to go try to get banned some more
59
60
:D
https://www.youtube.com/watch?v=HKWxigjAbp4
61
^ = power operator
62
like m2
63
meter squared
Yeah, knowing it's "the power of" makes it make more sense
64
1x1 meter
65
ask me a year ago and I wouldnt know either whats ^ :D
66
yup
Really? I guess I've learned a lot this year too. I've learned a lot just in the last 3 months. lol
67
I started to play in sheets since January 2019
68
total noob before that lol
69
nope :D
That's crazy! Surely you had some sort of experience with SOMETHING that helped you understand it
google is the secret weapon lol coz whatever you may ask you are like 50th dude to ask that question
70
never opened excell. I just played around in word and powerpoint
I mean, I had SOME experience with Excel before, but not much more than just summing a few cells
its all there just in other words
71
Well, you grasp it a LOT better than I do! lol I have to see the same thing 100x before it makes sense. lol
That's the trick. Figuring out how to ask it correctly
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100