Sum of divisions excel
Closed
LeBoums
Posted messages
7
Status
Member
-
krazykat Posted messages 11705 Registration date Status Contributor Last intervention -
krazykat Posted messages 11705 Registration date Status Contributor Last intervention -
Hello everyone,
Here's what I'd like to do:
A1/B1+A2/B2+...+A10/B10 but without considering the empty cells! That is, if cell A2 and B2 are empty, I want to display the result.
Thank you
Configuration: Windows 7 / Internet Explorer 8.0
Here's what I'd like to do:
A1/B1+A2/B2+...+A10/B10 but without considering the empty cells! That is, if cell A2 and B2 are empty, I want to display the result.
Thank you
Configuration: Windows 7 / Internet Explorer 8.0
3 answers
The SUMPRODUCT(Column1/Column2) function works, but it considers empty cells and gives me a DIV/0! error message on the result.
Hello,
Thank you for staying in this discussion:
https://forums.commentcamarche.net/forum/affich-24858433-moyenne-de-deux-colonnes-divisees-deux-a-deux
--
"Fukushima my love"
Goodbye to generational conflicts, everyone will have osteoporosis :-(
Thank you for staying in this discussion:
https://forums.commentcamarche.net/forum/affich-24858433-moyenne-de-deux-colonnes-divisees-deux-a-deux
--
"Fukushima my love"
Goodbye to generational conflicts, everyone will have osteoporosis :-(