as per ur sheet u can use below formula.
=SUMIF(B3:B10,B15,G3:G10)
On Fri, Sep 30, 2016 at 11:02 AM, N. Madhan wrote:
>
> Hi
>
> file attached sumif & sumifs function see that
>
> sumif function only single columns select
>
>
> On Friday, August 26, 2016 at 10:52:18 AM
use this
=SUM(VALUE(U18:U71))
On Thu, Sep 29, 2016 at 10:07 PM, N. Madhan wrote:
>
> HI
>
> can you see the sheet1 see the convert to number then =sum()
>
>
>
>
> On Thursday, September 1, 2016 at 11:21:24 PM UTC+5:30, khagesh khera
> wrote:
>>
>> Hi,
>>
>> Required