How do I make excel add in one column if conditions are met in ano
 

For example, I want to say, if anything in column A (from rows 1-20) =1, then
add whatever is in column B for that same row and put it in field G26. Then
I want to say, if anything in column A (from rows 1-20) = 2, then add
whatever is in column B for that same row and it it in field H26, and so on
through, if anything in column A (from rows 1-20) =8, then add whatever is in
column B for that same row and put it in field M26. Does anyone know how I
can do that??
--
Thanks!
Jodie

How do I make excel add in one column if conditions are met in ano
 

G26:M26 = 7 cells

Try this entered in G26 and copied across as needed:

=SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20)

--
Biff
Microsoft Excel MVP


"Jodie" wrote in message
...
For example, I want to say, if anything in column A (from rows 1-20) =1,
then
add whatever is in column B for that same row and put it in field G26.
Then
I want to say, if anything in column A (from rows 1-20) = 2, then add
whatever is in column B for that same row and it it in field H26, and so
on
through, if anything in column A (from rows 1-20) =8, then add whatever is
in
column B for that same row and put it in field M26. Does anyone know how
I
can do that??
--
Thanks!
Jodie

How do I make excel add in one column if conditions are met in
 

Wow. I'm stunned. It works great! You're right, I meant F26:M26. Thank
you SOOOO much!
--
Jodie


"T. Valko" wrote:

G26:M26 = 7 cells

Try this entered in G26 and copied across as needed:

=SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20)

--
Biff
Microsoft Excel MVP


"Jodie" wrote in message
...
For example, I want to say, if anything in column A (from rows 1-20) =1,
then
add whatever is in column B for that same row and put it in field G26.
Then
I want to say, if anything in column A (from rows 1-20) = 2, then add
whatever is in column B for that same row and it it in field H26, and so
on
through, if anything in column A (from rows 1-20) =8, then add whatever is
in
column B for that same row and put it in field M26. Does anyone know how
I
can do that??
--
Thanks!
Jodie

How do I make excel add in one column if conditions are met in
 

I meant F26:M26.

Just change the reference from $G26:G26 to $F26:F26.

=SUMIF($A1:$A20,COLUMNS($F26:F26),$B1:$B20)


--
Biff
Microsoft Excel MVP


"Jodie" wrote in message
...
Wow. I'm stunned. It works great! You're right, I meant F26:M26. Thank
you SOOOO much!
--
Jodie


"T. Valko" wrote:

G26:M26 = 7 cells

Try this entered in G26 and copied across as needed:

=SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20)

--
Biff
Microsoft Excel MVP


"Jodie" wrote in message
...
For example, I want to say, if anything in column A (from rows 1-20)
=1,
then
add whatever is in column B for that same row and put it in field G26.
Then
I want to say, if anything in column A (from rows 1-20) = 2, then add
whatever is in column B for that same row and it it in field H26, and
so
on
through, if anything in column A (from rows 1-20) =8, then add whatever
is
in
column B for that same row and put it in field M26. Does anyone know
how
I
can do that??
--
Thanks!
Jodie

Hi this has given me a head start in a formula I am looking for...

I would like certain conditions meet I.e if a cell = a certain name it then adds specific columns and returns an amount...

The amount of names at the moment is 10 but this will increase to 300/400

Any ideas?

Thanks