Help me to add particular cells

Solved/Closed
mathewmunna
Posts
27
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
Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
0
Yup...Thanks..
0