Summing if value is a weekend

**John007** · 01-09-2012, 07:50 PM

Hello,

I need to sum only the cells in a column if the date in another column is a weekend. I thought that =SUMIF(A5:A35,WEEKDAY(A5:A35,2)>5,X5:X35) would do the trick but it returns zero.

John

**Ron Coderre** · 01-09-2012, 07:57 PM

Try this regular formula

=SUMPRODUCT((WEEKDAY(A5:A35,2)>5)*X5:X35)

Does that help?

**John007** · 01-10-2012, 11:20 AM

Wow, I love this place! That does the trick. Spent a couple hours on that and in a matter of moments I get a solution. As always, once you see the solution, you ask, "Why didn't I see that?" Thanks!!!