Hi all,

I have a spreadsheet with two tabs

Tab A contains data (many fields across the row, hundreds of rows) based on daily values, and column C is the date column
Tab B is a summary sheet, and I am trying to do a simple count of how many instances based on the day of the week, from all the data in Tab A, using Tab A's date column.

Is the weekday element the wrong argument to use in this formula - and/or because Saturday is not normally classed as a weekday it could be forming the problem??

=SUMPRODUCT(--(WEEKDAY('Tab1'!$C$2:$C$510,11)=$A71))

$A71 is 6 ($B71 = Saturday, text field for end-user info purposes only)

The cells above this summary cell (in Tab B, $A66:$A70 (1 thru 5), $B66:$B70 are "Monday" thru "Friday") are calculating fine, but this one cell $A71 blows out by about 200 times the weekly count, when it should be less!
Just as an example of how much of a blow-out, the average for weekdays is 25, manually painful count average for Saturdays is 15, but $A71 is showing 380!

thanks in anticipation