With your data in row 15 and row 17 the something like this...
=SUMPRODUCT(--(B5:I5="S"),--(B7:I7="A"))
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"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