Count weekend days with criteria
Assuming that your days of the week are true dates:
=SUMPRODUCT(--(WEEKDAY(A1:H1,2)=6),--(A2:H2="A"))
--
Biff
Microsoft Excel MVP
"koob" wrote in message
...
G'day all
Is it possible to count Sat and Sunday's with certain criteria in the
cells.
eg.
M T W T F S S M
A A B A B A A B
I want to count the number of A's that occur on Saturdays and Sundays.
Thanks for any Help
|