SUMIF condition

[gtsolid]

Hi,
I wish to sum some numbers from the third row according to the start of the first one (I've attached an image).
The formula I used is not working but i don't understand why:
For example W1 is a Saturday, so the number in W3 should be added to the summation
How can I handle this?

[Sam Capricci]

A sumproduct might work best for this, but your image is not helpful. Please follow the instructions at the top of the post and upload a sample workbook WITH expected results and we can better help you.

[ChemistB]

My guess (and that's the best I can do unless you upload an example workbook as detailed in the yellow banner at the top of the page) is that the values in row 1 are formatted to begin with the weekday but are actually numbers/dates. You'd be able to see that in the formula bar. To SUM only Saturday dates, (assuming row 1 is actual dates)
=SUMPRODUCT((Weekday(B1:AF1,1)=7)*(B2:AF2))

[gtsolid]

Hi,
the first row is formatted in a way to show the dates in that way, but i can't use it into the SUMPRODUCT.
I've attached the file.

[ChemistB]

Okay, the first row is not actually dates, it's text. Try this formula

Please Login or Register  to view this content.

[gtsolid]

It works! what does it mean the "--" between brackets?

I have another question on the third row: it's used only as a support on the calculation on AL2.
Is there any way to avoid this trick?
My meaning is calculate how much the number in second row is major to 8 and the sum the result for each day (work overtime calculation).
Maybe

Please Login or Register  to view this content.

[ChemistB]

The -- changes TRUE/FALSE values into 1/0 values so that the SUMPRODUCT can do its thing. I'll have to give your second question some thought.