Want to use Vlookup and maybe SUMIF

[K0st4din]

Hello everyone, I'm completely lost and missing something.
I want to use Vlookup and maybe SUMIF so that it can return the searched word and add up the total of it.
Thanks in advance!

example koeficient.xlsm
	A	B	C	D	E
1	2024	1.2025	2.2025	3.2025
2	onko
3	urolo
4	kardi	3
5	kardi	44
6	psihi
7	kardi	3
8	kardi	4
9	kardi	19
10	psihi	1
11	kardi	22
12	kardi
13	kardi
14	psihi
15	endo	9
16	endo
17	endo	1
18	endo
19	psihi	6
20	urolo	14
21	psihi
22	psihi	4
23	kardi	1
24	kardi	43
25	kardi
26	onko
27	psihi	4
28	psihi
29	psihi
30	kardi	3
31	nevro	1
32	nevro	5
33	kardi	18
34	kardi	1
35	pulmo
36	pulmo
37	endo
38	endo
39	endo	6
40	endo
41	endo
42	endo	1
43	pulmo
44	pulmo
45	pulmo
46	pulmo	3
47	pulmo
48	pulmo
49	kardi	16
50	psihi	3
51	nevro	5
52	nevro
53	kardi	9
54	urolo	1
55	urolo	20
56	urolo
57	urolo
58	urolo	6
59	urolo	56
60	urolo	4
61	nevro
62	urolo	35
63	urolo	42
64	pulmo
65	pulmo
66	onko
67	pulmo
68	onko
69	onko
70	onko
71	onko
72	onko
73	onko
74	onko
75	onko
76	onko
77	onko
78
79		408
80
81			results must be
82	diviz
83	endo		61
84
85	kardi		434
86
87	nevro		12
88
89	onko
90
91	psih		45
92
93	pulmo		25
94
95	revm
96
97	urolo		190
98
99	TOTAL:
Sheet1

 

[StephenCrump]

Perhaps you could start by telling us how you calculated your results?

It's not at all clear where VLOOKUP might fit in. (Just a guess, perhaps you want to specify word and month, and sum the appropriate column?)

And a SUMIF(S) returns very different results to what you've posted:

	A	B	C	D
79		408.2
80
81			results must be
82	endo		61	16.9
83	kardi		434	182.5
84	nevro		12	10.7
85	onko			0.0
86	psihi		45	17.2
87	pulmo		25	3.0
88	urolo		190	178.0
89
90	TOTAL:		767	408.2
Sheet1

Cell Formulas
Range	Formula
D82:D88	D82	=SUMIFS(B$2:B$77,A$2:A$77,A82)
C90:D90	C90	=SUM(C82:C88)

 

[saboh12617]

Hello,

I guess some values are missing in your example because values do not add up to the ones you gave as example.

The sumif syntax is this one (for C82, to extend downwards)

=SUMIF($A$2:$A$77, $A82, $B$2:$B$77)

 

[K0st4din]

Yes, of course the result is exactly what you showed.
My calculations are wrong.
That's exactly what I wanted to get as a result.
Thank you very much for the quick response.
Stay safe and healthy.