If multiple cells contain value then add value
Solved/Closed
Related:
- If multiple cells contain value then add value
- Based on the value in cells b77 ✓ - Excel Forum
- How to make multiple selections in photoshop - Guide
- Can you log into instagram on multiple devices - Instagram Forum
- Mpc hc multiple instances - Guide
- Based on the values in cells b77 b88 ✓ - 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