E
Eva
Can you help me with the following sytuation
I have data in sheet1 in a vertical order
Sheet1
A B C D
data Info1 Info2 Info3
information 55 5 -1
information -5 -9 2
In sheet2 I need to sum values that are less than 0
Sheet2
Info1 =SUMIF(B3:B5,"<0",B3:B5)
Info2 =SUMIF(c3:c5,"<0",c3:c5)
Info3
The problem is that I don't want to change manually range of each one
category
I need a range to be more flexable.
Is it possible to do it?
Thanks
Eva
I have data in sheet1 in a vertical order
Sheet1
A B C D
data Info1 Info2 Info3
information 55 5 -1
information -5 -9 2
In sheet2 I need to sum values that are less than 0
Sheet2
Info1 =SUMIF(B3:B5,"<0",B3:B5)
Info2 =SUMIF(c3:c5,"<0",c3:c5)
Info3
The problem is that I don't want to change manually range of each one
category
I need a range to be more flexable.
Is it possible to do it?
Thanks
Eva