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

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

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