Formula for calculating the sum of values from an array.
Good day. There is a file in one column of the category in another numeric values. I am looking for a way to get the sum for each value. I tried "VLOOKUP", but it finds only one. I also did not understand how to configure "arrayformula sum vlookup", as if it searches only by columns of values, and not by all rows. If anyone knows, please tell me.
Original question is available on version: ru
Answers:
Good afternoon, give an example of the entire table!
12.08.2024, 09:46
Original comment available on version: ua
nutrition 254 Finished result:
nutrition 5818
nutrition 5564 travel 255
travel 222, taxi 610
road 33 service 47
Taxi 44
Taxi 566
service 35
service 12
There is the first table with categories and numbers, we select it in its entirety and write =UNIQUE($M$23:$M$30) then we select unique categories and we can already do the following actions on them: =SUMIF($M23:$M30;$O23 ;$N23:$N30) where $M23:$M30 is the table range with repeating values, $O23 is our unique category value, $N23:$N30 is the range of numbers from the repeating table.
nutrition 5818
nutrition 5564 travel 255
travel 222, taxi 610
road 33 service 47
Taxi 44
Taxi 566
service 35
service 12
There is the first table with categories and numbers, we select it in its entirety and write =UNIQUE($M$23:$M$30) then we select unique categories and we can already do the following actions on them: =SUMIF($M23:$M30;$O23 ;$N23:$N30) where $M23:$M30 is the table range with repeating values, $O23 is our unique category value, $N23:$N30 is the range of numbers from the repeating table.
12.08.2024, 13:14
Original comment available on version: ua
https://docs.google.com/spreadsheets/d/1qyi5n8yNvpHe2FlheqZywjkxuNBvJDRmNzAnsIHl...
I'm going to output the amounts for each position in a separate place, taking the values from the array.
I'm going to output the amounts for each position in a separate place, taking the values from the array.
19.08.2024, 13:33
Original comment available on version: ru
=SUMIF(C1:C999; I2; D1:D99) Thank you very much, it worked!
19.08.2024, 14:17
Original comment available on version: ru
I think it's faster and better for you to look for solutions to such issues on forums/documentation for Excel :)
22.08.2024, 09:54
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
