Ask Your Question
0

Somme colum A when something is in colum B

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

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
1

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

mark_t gravatar image

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

=SUMIF(B1:B5,"<>",A1:A5)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 305 times

Last updated: Aug 13 '16