Count weekend days with criteria

  • Thread starter Thread starter koob
  • Start date Start date
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
 
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"))
 
Back
Top