Ask Your Question
0

Sum column A when something is in column B [closed]

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

vitesse gravatar image

updated 2020-09-10 14:46:33 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 14:45:52.668192

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

Question Tools

1 follower

Stats

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

Seen: 335 times

Last updated: Sep 10