Please help slightly change the formula

[K0st4din]

Hello everyone, please for your assistance in correcting the formula.
I have two worksheets:
In Sheet2 in column A - I have different dates (2.6.2020, 15.6.2020, ect. down)
in column B - I have different words (from the drop-down menu)
in column H - I have prices for this Words
I'm trying in Sheet1 to compare
In column A (vertically) is the calendar month and in column G I need if the word on the same date (for example it has 2 times 20 dollars), in this column G of the corresponding row to add me and I see a result of 40 dollars .
The formula that worked was as follows:

=IF(SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;{"1"}))=0;"";SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;{"1"})))

The problem is this {1} or {2}, {3} - Because before he recognized it, obviously as a word, and now I want to take it from the date 1.6.2020
But this 1 was text and for many other reasons it is now 1 again, but from 1.6.2020 (which is already a date).
My problem is that I don't know how to read 1 from the date to get the sum.
I ask for some assistance on your part.
Thank you in advance

 

[K0st4din]

Sheet2

Sheet1

 

[K0st4din]

I also attach an example because I showed the wrong one in the photo
example.xlsm
in google drive

example.xlsm

drive.google.com

 

[CA_Punit]

Just change 1 to DATE(YYYY,MM,DD) or change it cell reference

 

[CA_Punit]

=SUM(SUMIFS(Sheet2!H:H,Sheet2!B:B,{"food","House","Auto"},Sheet2!A:A,Sheet1!A2))

With Control+Shift+Enter

 

[K0st4din]

Thank you very much for your cooperation.
I also put an IF because when there are no values it shows me 0-zero.
Can I put it on again and again Control+Shift+Enter

 

[CA_Punit]

You can use
this to avoid Ctrl+Shift+Enter and will not get 0 if there is no data in the range

New Microsoft Excel Worksheet.xlsx
	E	F	G	H
7	1
8	2
9	3		1
10	4
11
12
Sheet1

Cell Formulas
Range	Formula
G9	G9	=AGGREGATE(15,6,E7:E10/(E7:E10>0),1)

 

[K0st4din]

=IF(SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;{"1"}))=0;"";SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;{"1"})))
Will we be able to explain things a little, because it is not very clear to me?
above is my currently not working formula
You mean to replace this {1} with DATE (dd; mm; yyyy) - (this is the case when it's only for example for the 6th month, and for me it will change every month and if I have to go in to change months each time, not a good option -> If I understood correctly.
Example if it is this month, the formula should be DATE (1.6.2020), the next will have to change again 31 days (lines).
=IF(SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;DATE(01;06;2020)))=0;"";SUM(SUMIFS(Sheet2!$H$6:$H$65;Sheet2!$B$6:$B$65;{"Good";"food";"house"};Sheet2!$A$6:$A$65;DATE(01;06;2020))))

-------------------------------------------------------------------
The last one with AGGREGATE I didn't understand at all.
where do these 15, 6 come from?
------------------------------------------------------------------------
regarding this formula:
=SUM(SUMIFS(Sheet2!H:H,Sheet2!B:B,{"food","House","Auto"},Sheet2!A:A,Sheet1!A2))
or
=SUM(SUMIFS(Sheet2!$H$6:$H$65,Sheet2!$B$6:$B$65,{"food","House","Auto"},Sheet2!$A$6:$A$65,Sheet1!A2))
In my case all letters (columns) are in the range A6:A65, B6:B65, H6:H65, in sheet2.
In this case with $ or without $ to write them?

 

[CA_Punit]

Please ignore the Post 7. Mistakenly i posted someone else query here.

 

[K0st4din]

Please ignore the Post 7. Mistakenly i posted someone else query here.

OK
can we discuss this formula, because the moment I hit Ctrl+Shift+Enter - "OPEN File" opens - I mean ctrl + o
regarding this formula:
=SUM(SUMIFS(Sheet2!H:H,Sheet2!B:B,{"food","House","Auto"},Sheet2!A:A,Sheet1!A2))
or
=SUM(SUMIFS(Sheet2!$H$6:$H$65,Sheet2!$B$6:$B$65,{"food","House","Auto"},Sheet2!$A$6:$A$65,Sheet1!A2))
In my case all letters (columns) are in the range A6:A65, B6:B65, H6:H65, in sheet2.
In this case with $ or without $ to write them?
I try it, but things don't work out for me.
if you find it easier, I have attached an example, write it there and I will download the file.