Array Fomula Sum Data For Days 6 & 7 Only

[Greg]

Hi,

Hoping someone can help me with something that should be easy.

I have data in the following format:

A B
Date Data
Date Data
Date Data

I want to add up the data for days 6 & 7 only.

I was starting to work with the following:

=SUM(IF(WEEKDAY((AH6:AH36)=6)*WEEKDAY((AH6:AH36)=7),(AO6:AO36))

but can't get the fomat right. Have tried many variations and can't
seem to find any reference in the newsgroups or on mircosoft.com
website.

Thanks for the help!

 

[Greg]

Thanks Robert.

I get the following to work after some banging away at the keyboard:

=SUM(IF((WEEKDAY(AH7:AH37)=6)+(WEEKDAY(AH7:AH37)=7),AO7:AO37)

I will play around with the sumproduct also.

Cheers.