If statements (1 Viewer)

I have this formula in a cell but dont want it to add the Salaries if one or both of 2 other fileds are empty.

=SUM(D3546)+Salaries!C5+Salaries!C6

Salaries!C5 needs to be added only if cell D34 has a value
Salaries!C6 needs to be added only if cell D47 has a value

I cant figure out how the statement would be, any help would be appreciated...

Howdy.

=IF(OR(Salaries!C5="",Salaries!C6=""),"",SUM(D35: D46))

See if this works for you, and if I have understood your setup.
________
Buy Herbalaire Vaporizer

You haven't responded to the previous post but the reply was not how I understood the question, I read it that you require

If a blank is also considered not to be a value then


Brian