How to select/filter rows in MS Excel based on cell value -

How to select/filter rows in MS Excel based on cell value -

i'm working on excel sheet has simple construction this.

date | order ----------------------- 08-15-2014 | 84 08-16-2014 | 50 08-17-2014 | 68 08-17-2014 | 78 08-18-2014 | 23

here, in separate column i'd calculate sum of orders week days(sunday, mon , on). meaning, want see how many orders received on sunday, mon etc.

so far have come non working formula.

=sum(lookup(1, weekday(date_column), order_column))

this illustration summing order received on sunday. and, yes date column in datetime info type shouldn't problem.

thanks.

consider adding new column after dates, representing day values. in column b might have =text(weekday(a2),"ddd").

then if wanted sum order numbers day, utilize equation =sumif(b1:b5,"sun",c1:c5) column b has day values , column c has order numbers.

to show illustration (with headers, etc):

excel row filtering