View Single Post
 
Old 02-26-2015, 02:45 PM
676nova 676nova is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Feb 2015
Posts: 3
676nova is on a distinguished road
Default

Ah! Peco's did work, of course! I needed to modify the arguments to "WEEKDAY(A2:A6,2)" for it to work correctly in the actual spreadsheet where I want to use this. I can't explain why, but there is something about SUMPRODUCT that confuses my. I think it has to do with using "*" in the equation to "multiply" things when you are actually not performing any multiplication. In any event, THANKS to everyone for such fast responses. I have loved Excel since it first came out, and it seems there is very little it can't do
Reply With Quote