How to ask excel to sum value of a column, but if column in empty, refer to another column

[runlulurun]

Hi
I'm hoping someone can help! I usually google for answers, but I'm struggling to describe what it is that I want to do with the right terms.

I am tracking pipeline business in an excel spreadsheet on sharepoint.

Throughout the sales process, there are 3 stages at which we record potential fees, becoming more accurate as you go through the process. I am trying to build a formula that says 'look at value in column C, unless it is empty, then look at B, and if that's empty, look at A'.

Would anyone be able to point me in the right direction of how to do this?

[Glenn Kennedy]

In the absence of a sample file, showing expected answers....


maybe:

=IF(C3<>"",C3,IF(B3<>"",B3,IF(A3<>"",A3,"")))

[runlulurun]

I love you! That's perfect and works exactly as I need it too.

I hope lots of wonderful things come your way

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.