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

 

[CA_Punit]

I have framed your question on the basis of my drawn data.

Please care to change the reference cell to meet your requirment.

Please put the Date in a specific cell and refer to that cell in the sumif formula. You dont have to change in the 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.

Please explain how do you want the report to be like monthwise/Date wise ???

 

[K0st4din]

My mistake is because I have given an example for sheet1, I have of course another name and I forgot to put 'Name of sheet', ie the sign '
Everything is fine.
Thank you so much
I am infinitely grateful!
A bow

 

[CA_Punit]

You are Welcome