if then else

[Sandy]

I have 14 columns and say 20 rows of data where the data could be 7 different
text values at any given time, I need to total the values some where for
those 7 different text values. The values I need to total are in the columns
next to the original 14 I spoke of.

ex: a b f g
s 3 w 2
s 4 s 3
n 5 w 4

Totals for s=10
w=2
n=5

if any cell in columns a or f = s then add the value from the cell to the
right to a running total some where

[Morrigan]

=SUMIF($A$1:$M$20,"s",$B$1:$N$20)
=SUMIF($A$1:$M$20,"w",$B$1:$N$20)
=SUMIF($A$1:$M$20,"n",$B$1:$N$20)

Hope it helps

I have 14 columns and say 20 rows of data where the data could be 7 different
text values at any given time, I need to total the values some where for
those 7 different text values. The values I need to total are in the columns
next to the original 14 I spoke of.

ex: a b f g
s 3 w 2
s 4 s 3
n 5 w 4

Totals for s=10
w=2
n=5

if any cell in columns a or f = s then add the value from the cell to the
right to a running total some where

[Sandy]

perfect
Thanks

"Morrigan" wrote:

>
> =SUMIF($A$1:$M$20,"s",$B$1:$N$20)
> =SUMIF($A$1:$M$20,"w",$B$1:$N$20)
> =SUMIF($A$1:$M$20,"n",$B$1:$N$20)
>
> Hope it helps
>
>
> Sandy Wrote:
> > I have 14 columns and say 20 rows of data where the data could be 7
> > different
> > text values at any given time, I need to total the values some where
> > for
> > those 7 different text values. The values I need to total are in the
> > columns
> > next to the original 14 I spoke of.
> >
> > ex: a b f g
> > s 3 w 2
> > s 4 s 3
> > n 5 w 4
> >
> > Totals for s=10
> > w=2
> > n=5
> >
> > if any cell in columns a or f = s then add the value from the cell to
> > the
> > right to a running total some where
>
>
> --
> Morrigan
> ------------------------------------------------------------------------
> Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
> View this thread: http://www.excelforum.com/showthread...hreadid=522784
>
>