View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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