V
via135
hi
can i sumup a full column list using "sumif", with more than one
criteria, all based on a single coloum? for example i am having data in
A1:C4
60 80 70
50 30 40
20 40 70
100 60 80
what i want is the sum C1:C4 if either "A1>=50 *or* A4<100", likewise
"A2=50 *and* A4=100"..and so on!
help pl?
-via135
can i sumup a full column list using "sumif", with more than one
criteria, all based on a single coloum? for example i am having data in
A1:C4
60 80 70
50 30 40
20 40 70
100 60 80
what i want is the sum C1:C4 if either "A1>=50 *or* A4<100", likewise
"A2=50 *and* A4=100"..and so on!
help pl?
-via135