Need formula to sum cells

[NightKnight]

It looks to me like an easy one, but I had spent hours trying to find the answer:
In range A1:A5 I have values.
I can enter a value only in B1 OR B2.
I need in C1 a formula that will tell: If B1 and B2 are empty, do nothing; if not, take the value from B1 or B2 and add it to the sum of A1:A5.
Thanks in advance.
NK

 

[VoG]

Try

=IF(AND(B1="",B2=""),"",IF(B1="",SUM(A1:A5,B2),SUM(A1:A5,B1)))

 

[T. Valko]

It looks to me like an easy one, but I had spent hours trying to find the answer:
In range A1:A5 I have values.
I can enter a value only in B1 OR B2.
I need in C1 a formula that will tell: If B1 and B2 are empty, do nothing; if not, take the value from B1 or B2 and add it to the sum of A1:A5.
Thanks in advance.
NK

I interpret that highlighted statement to mean that only one of the cells, if any, will contain an entry.

=IF(B1&B2="","",SUM(A1:A5,B1:B2))

 

[Aladin Akyurek]

It looks to me like an easy one, but I had spent hours trying to find the answer:
In range A1:A5 I have values.
I can enter a value only in B1 OR B2.
I need in C1 a formula that will tell: If B1 and B2 are empty, do nothing; if not, take the value from B1 or B2 and add it to the sum of A1:A5.
Thanks in advance.
NK

If both B1 and B2 have a value, what would be the desired action.

If just B1 or B2 a value or none has a value:

=SUM(A1:A5,B1:B2)

would also suffice.

 

[NightKnight]

Thank you T. Valko and VoG. I appreciate your answers. Both of them work (of course!)
(It's so easy to do things when you know WHAT to do)....

 

[NightKnight]

Sorry Aladin. Didn't see your reply when I previously posted.
With yours I have a problem that when B1 and B2 are empty I get the sum of A1:A5 and I want C1 empty if B1 and B2 are empty.
Thanks anyway.

 

[T. Valko]

Thank you T. Valko and VoG. I appreciate your answers. Both of them work (of course!)
(It's so easy to do things when you know WHAT to do)....

You're welcome. We appreciate the feedback!

 

[Aladin Akyurek]

Sorry Aladin. Didn't see your reply when I previously posted.
With yours I have a problem that when B1 and B2 are empty I get the sum of A1:A5 and I want C1 empty if B1 and B2 are empty.
Thanks anyway.

Right. How about some caution...

=IF(COUNT(B1:B2)=1,SUM(A1:A5,B1:B2),"")

in case both B1 and B2 have values?

 

[NightKnight]

Well... feedback is almost the only way of showing appreciation, isn't it?
Aladin, thanks for the "fix"... now it's OK!
Have a good coming week guys!

 

[Aladin Akyurek]

Well... feedback is almost the only way of showing appreciation, isn't it?
Aladin, thanks for the "fix"... now it's OK!
Have a good coming week guys!

Yep... Thanks for providing feedback.