Count weekend days with criteria

K

koob

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
 
J

Jim Cone

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
 
T

T. Valko

Assuming that your days of the week are true dates:

=SUMPRODUCT(--(WEEKDAY(A1:H1,2)>=6),--(A2:H2="A"))
 
Top