Prev: excel 2007 filter 3 text values at the same time from the same co.
Next: Leading zero's trail Number
From: ASB on 6 Apr 2010 15:59
I am looking for a function that works using a =sumif function to add things
that are not in a range that are next to each other as seen below the letters
in () are the columns that the values are in...

so I am looking for a sum in column A "X" of the total work out time if the
appl column is "Y"

total work Running (D) Walking (F)
Elliptical (H)
out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl (H)
Time (I)
X Y 20 N 0
Y 30

example: row sum X=50 min of work out to show up in column A based on Y's in
the other columns associated

I tried =SUMIF((D6,F6,H6),Y,(E6,G6,I6)) but i get the value error

Any suggestions? Thanks!
From: Paul on 6 Apr 2010 20:57

Try something like:

=SUMIF(D6:H6,"Y",E6:I6)




A
S
B
;
6
9
1
9
4
8

W
r
o
t
e
:


>
I am looking for a function that works using a =sumif function to add
things
> that are not in a range that are next to each other as seen below the
letters
> in () are the columns that the values are in...
>
> so I am looking for a sum in column A "X" of the total work out time if
the
> appl column is "Y"
>
> total work Running (D) Walking (F)
> Elliptical (H)
> out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl
(H)
> Time (I)
> X Y 20 N 0
> Y 30
>
> example: row sum X=50 min of work out to show up in column A based on
Y's in
> the other columns associated
>
> I tried =SUMIF((D6,F6,H6),Y,(E6,G6,I6)) but i get the value error
>
> Any suggestions? Thanks!


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=193445

http://www.thecodecage.com/forumz

From: T. Valko on 6 Apr 2010 21:11
Try this...

=SUMIF(D6:H6,"Y",E6:I6)

Note how the ranges are offset.

D..E..F..G..H
......E..F..G..H..I

--
Biff
Microsoft Excel MVP


"ASB" <ASB(a)discussions.microsoft.com> wrote in message
news:4C3DE2AB-23A1-4EF5-843E-83EF582AE47C(a)microsoft.com...
>I am looking for a function that works using a =sumif function to add
>things
> that are not in a range that are next to each other as seen below the
> letters
> in () are the columns that the values are in...
>
> so I am looking for a sum in column A "X" of the total work out time if
> the
> appl column is "Y"
>
> total work Running (D) Walking (F)
> Elliptical (H)
> out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl (H)
> Time (I)
> X Y 20 N 0
> Y 30
>
> example: row sum X=50 min of work out to show up in column A based on Y's
> in
> the other columns associated
>
> I tried =SUMIF((D6,F6,H6),Y,(E6,G6,I6)) but i get the value error
>
> Any suggestions? Thanks!


 | 
Pages: 1
Prev: excel 2007 filter 3 text values at the same time from the same co.
Next: Leading zero's trail Number