Ask Your Question

Somme colum A when something is in colum B

asked 2016-08-13 19:48:05 +0200

vitesse gravatar image

I have two colum, the first one have number on it and the second one have some cell filled.

how could i do a conditional somme instruction for calculating only number that have a corespondiong not empty cell?

Had not found how to do that complexe function :(

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-13 22:57:01 +0200

mark_t gravatar image

Where A1:A5 contains the numbers and B1:B5 the are cells to be not empty.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-13 19:48:05 +0200

Seen: 310 times

Last updated: Aug 13 '16