SumIf right = 1
Hi.
My value in column a a
1.2
7.1
4.2
4.1
......
if the the value is 1 I want to SUM.
such as 7.1 and 4.1
if you make a right 1 to this you will get the result = 1
So I want to sum if right is 1, witch will sum 4.1 and 7.1
Regards,
Marco
"Stephen" wrote:
"Marco" wrote in message
...
Hi. I need to make a sum if from A5 to B100 if right A5:A100 =1
So what I mean is only sum if right A = 1
when I say A I mean:
A1
A2
A3
A....
regards,
Marco
This formula will sum values in B5:B100 where the corresponding value in
A5:A100 equals 1:
=SUMIF(A5:A100,1,B5:B100)
I don't understand what you mean by "right A", though. Post back explaining
this if you need more help.
|