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 UTC+5:30, Deepak Rawat
Hi
file attached sumif & sumifs function see that
sumif function only single columns select
On Friday, August 26, 2016 at 10:52:18 AM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> Need sumif function to sum multiple columns
>
> sample excel attached.
>
> Regards,
> Deepak
>
--
Are you =EXP(E:R