"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.