Not Same Row Formula...
 

I'm having trouble with one of my files in excel. Basically I want it to be
so that if a cell in column AH4:AH127 has T1 in it, then I want the sum of
the cells in column AG4:AH127 that are one row above where it has the T1 in
AH. for example if AH12 and AH55 have T1 in them, then I want the sum of
AG11 and AG 54.

I can't move the values from AG to be in the same row as the T1 in AH
because there is already other data there.

Any help??

Not Same Row Formula...
 

Offset your arrays in a SUMIF function like so:

=SUMIF(AH4:AH127,"T1",AG3:AG126)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lightbulb" wrote:

I'm having trouble with one of my files in excel. Basically I want it to be
so that if a cell in column AH4:AH127 has T1 in it, then I want the sum of
the cells in column AG4:AH127 that are one row above where it has the T1 in
AH. for example if AH12 and AH55 have T1 in them, then I want the sum of
AG11 and AG 54.

I can't move the values from AG to be in the same row as the T1 in AH
because there is already other data there.

Any help??

Not Same Row Formula...
 

How do I get this to apply only to visible cells; to not include hidden rows?

Thanks!

"Luke M" wrote:

Offset your arrays in a SUMIF function like so:

=SUMIF(AH4:AH127,"T1",AG3:AG126)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lightbulb" wrote:

I'm having trouble with one of my files in excel. Basically I want it to be
so that if a cell in column AH4:AH127 has T1 in it, then I want the sum of
the cells in column AG4:AH127 that are one row above where it has the T1 in
AH. for example if AH12 and AH55 have T1 in them, then I want the sum of
AG11 and AG 54.

I can't move the values from AG to be in the same row as the T1 in AH
because there is already other data there.

Any help??