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
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
Last edited by John007; 01-10-2012 at 12:21 PM.
Try this regular formula
Does that help?Please Login or Register to view this content.
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!!!
You're welcome...Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks