K0st4din
Active Member
- Joined
- Feb 8, 2012
- Messages
- 488
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
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:
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
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:
Rich (BB code):
=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"})))
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