How to extract sumifs data based on date

[arsyan]

I need extract data in one month per day, but only in name of date like sunday, monday
already know how sumifs works but the problem is date formula can't extract the data except the data must have match case
note : the data in coloumn 3 only contain 7 row, name of 7 days, not the date name off all dates

date	product	days	final
Sunday, 02 September 2019	2	sunday	?
Monday, 03 September 2019	10	Monday	?
Tuesday, 04 September 2019	3	Tuesday	?
Wednesday, 05 September 2019	5	Wednesday	?

[Pete_UK]

List the days of the week (Sunday, Monday, Tuesday etc.) in the cells E2:E8, then you can use this formula in F2:

=SUMPRODUCT(--(TEXT($A$2:$A$20,"dddd")=E2),$B$2:$B$20)

Copy down to F8.

Hope this helps.

Pete

[arsyan]

sorry i thought its not working, i delete your "--"
but its working thank you

[Pete_UK]

Here's the file I worked on:

Hope this helps.

Pete

[avk]

In "C2"

Please Login or Register  to view this content.

In "D2"

Please Login or Register  to view this content.

Copy paste down.

[arsyan]

can you explained what "--" in (--( supposed to mean?

[Pete_UK]

Each element of the range $A$2:$A$20 will be compared with E2 to see if there is a match. This will result in an array made up of TRUE or FALSE values. The double unary minus ( -- ) will convert (coerce) this into an array of 1s and 0s, and each element of that will be multiplied by the corresponding element of the range $B$2:$B$20 and the result will then be added together. Obviously, zero times anything results in zero, so effectively the formula will sum the values from column B where column A cells are for the day of the week given in column E.

Hope this helps.

Pete