MOD FORMULA

sachar · May 9, 2015

Dear All,

With reference to the attachment, may i know how to extract the only "sum" value from "B" column to Column "E" with help of MOD FORMULA?

NARAYANK991 · May 9, 2015

Hi ,

I have not understood your requirement , but is it like this ?

=SUMIF($D$2:$D$17,1,$B$2:$B$17)

Narayan

sachar · May 10, 2015

Dear Sir,

Sorry for that, what I like to get it that is in column “E” but, with formula. Sample file attached.

NARAYANK991 · May 10, 2015

Hi ,

See the attached file.

Narayan

sachar · May 10, 2015

Dear Narayank,

Received with thanks.

Syedali · May 11, 2015

I thinks this also will work =IF(D2=0,B2,"")

Khalid NGO · May 11, 2015

Or this without helper cells:
=IF(MOD(B2,2)=0,B2,"")

sachar · May 11, 2015

Dear All,

Thanks yours, help me to solve my problems in an easy way.