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
- Allow multiple downloads chrome - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- How to delete multiple files on mac - Guide
- Photoshop multiple selections - Guide
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