If multiple cells contain value then add value
Solved/Closed
Related:
- If multiple cells contain value then add value
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Allow multiple downloads chrome - Guide
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
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