If multiple cells contain value then add value
Solved/Closed
Related:
- If multiple cells contain value then add value
- If cell contains date then return value ✓ - Excel Forum
- How to download multiple files from whatsapp web - WhatsApp Forum
- Excel formula to check if cell contains a date - Excel Forum
- Allow multiple downloads chrome - Guide
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 27, 2016 at 09:51 AM
Jul 27, 2016 at 09:51 AM
Robert Bell, Good morning.
a) Change the "" to zero
Before:IF(A2<>"",25,"")+IF(A3<>"",25,"")+IF(A4<>"",25,"")
Now...:IF(A2<>"",25,0)+IF(A3<>"",25,0)+IF(A4<>"",25,0)
b) Try to use another formula
=COUNT.IF(A2:A4,"<>")*25
Is this what you want?
I hope it helps.
a) Change the "" to zero
Before:IF(A2<>"",25,"")+IF(A3<>"",25,"")+IF(A4<>"",25,"")
Now...:IF(A2<>"",25,0)+IF(A3<>"",25,0)+IF(A4<>"",25,0)
b) Try to use another formula
=COUNT.IF(A2:A4,"<>")*25
Is this what you want?
I hope it helps.
Aug 3, 2016 at 10:32 AM
Cheers mate