Help me to add particular cells
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday 18 November 2014
Status
Member
Last seen
21 May 2015
-
10 Dec 2014 à 00:15
mathew munna - 15 Dec 2014 à 00:57
mathew munna - 15 Dec 2014 à 00:57
Related:
- Based on the values in cells b77 b81
- Based on the values in cells b77 - Best answers
- Based on the cell values in cells b77 - Best answers
- Based on the cell values in cells b77 ✓ - Excel Forum
- Fill adjacent cell with number from text answer ✓ - Excel Forum
- Excel function question - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Based on the values in cells b77 - Excel Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
10 Dec 2014 à 08:27
10 Dec 2014 à 08:27
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
15 Dec 2014 à 00:57