Help me to add particular cells
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Dec 10, 2014 at 12:15 AM
mathew munna - Dec 15, 2014 at 12:57 AM
mathew munna - Dec 15, 2014 at 12:57 AM
Related:
- Based on the values in cells b77 b81
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? - Best answers
- Based on the values in cells b77 b81 c77 - Best answers
- Fill adjacent cell with number from text answer ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Code to move rows into another sheet based on certain values ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 10, 2014 at 08:27 AM
Dec 10, 2014 at 08:27 AM
mathewmunna, Good morning.
Try to use:
=IF(COUNTIF($B$81:$BH$81,7)>0,SUM($B$77:$BH$77);0)
Is this what you want?
Hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=IF(COUNTIF($B$81:$BH$81,7)>0,SUM($B$77:$BH$77);0)
Is this what you want?
Hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Dec 15, 2014 at 12:57 AM