Sum if empty
Solved
NulsurExcel
-
NulsurExcel! Posted messages 1 Status Membre -
NulsurExcel! Posted messages 1 Status Membre -
Hello,
I have a range from A3 to A18 with amounts in €, and in an adjacent range, I have written next to each amount whether it has been paid or not.
I would like a formula in a cell below that allows me to know the total amount from the range A3 to A18 that has not yet been paid.
So, the amount from A3 to A18 if the range B3 to B18 is empty. (because if it's empty, it means it hasn't been paid.)
HELP
Thank you
Configuration: Windows 7 / Chrome 33.0.1750.146
I have a range from A3 to A18 with amounts in €, and in an adjacent range, I have written next to each amount whether it has been paid or not.
I would like a formula in a cell below that allows me to know the total amount from the range A3 to A18 that has not yet been paid.
So, the amount from A3 to A18 if the range B3 to B18 is empty. (because if it's empty, it means it hasn't been paid.)
HELP
Thank you
Configuration: Windows 7 / Chrome 33.0.1750.146
3 réponses
Hello,
Suppose you mark "Paid" (or settled, or in any case something when it’s well paid ^^) in column B:
You place this code anywhere in column A, below the values.
"It is better to know how to seek than to seek to know everything."
"Internet is actually an acronym for: Unpredictable Nocturnal Traveler Carrying a Collection of Gossips and Eminently Trivial News."
Suppose you mark "Paid" (or settled, or in any case something when it’s well paid ^^) in column B:
=SUMIF(B3:B18;"";A3:A18)
You place this code anywhere in column A, below the values.
"It is better to know how to seek than to seek to know everything."
"Internet is actually an acronym for: Unpredictable Nocturnal Traveler Carrying a Collection of Gossips and Eminently Trivial News."
