Sumif across a table


A

ASB

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!
 
Ad

Advertisements

T

T. Valko

Try this...

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

Note how the ranges are offset.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top