Re: If Statements

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 09/09/04 

Date: Thu, 09 Sep 2004 07:55:36 -0600

one way:

    =SUMIF(B:B,"Monday",A:A)

If you need Tuesday and Wednesday, too, try a Pivot Table:

    http://peltiertech.com/Excel/Pivots/pivotstart.htm

In article <15E13DB5-FCA4-4F20-872C-C5B97AD6682C@microsoft.com>,
 cdspnr <cdspnr@discussions.microsoft.com> wrote:

> 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.

Quantcast