Hi
Thank you for the formula ,it is working well,
Rajesh
On Wednesday, December 26, 2012 11:24:08 AM UTC+5:30, Ms-Exl-Learner wrote:
>
> *In C16** cell*
> =IF(ISNUMBER(B16),TEXT(B16,""),"")
> *Drag it down.*
>
> *In D2 cell*
> =SUMIF($C$16:$C$380,$B2,(D$16:D$380))
> *Drag it to right...*
>
*In C16**cell*
=IF(ISNUMBER(B16),TEXT(B16,""),"")
*Drag it down.*
*In D2 cell*
=SUMIF($C$16:$C$380,$B2,(D$16:D$380))
*Drag it to right...*
On 26-12-2012 11:24 AM, Rajesh thrissur wrote:
Hi Experts,
In the attachment file the sumif formula is not working I don't know
why.kindly point the mi
