If Statements

From: cdspnr (cdspnr_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 06:41:02 -0700

I have 2 columns...1 is revenue and the other is day of the week. what I
need for it to figure is...If I have revenue on monday, tuesday and wednesday
I need a formua that the spread*** will take all the monday sales and
seperate it from Tuesday and wednesday. ex..
$245 Monday
$456 Monday
$789 Tuesday
$1000 Wednesday
I am sure it would be something like =if(a24="monday", I don't know how to
complete it so it adds only monday and leaves out tuesday.