Re: $$Excel-Macros$$ Sum query

2013-07-24 Thread ravinder negi
=SUMIF($A$4:$A$54,H4,$B$4:$B$54) use this formula From: suresh k To: Excel group Sent: Wednesday, July 24, 2013 6:20 PM Subject: $$Excel-Macros$$ Sum query Hi All, I have attached my query regarding sum function query I know this can be solved through

Re: $$Excel-Macros$$ Sum query

2013-07-24 Thread Waseem Saifi
You can use Sumif It's so simple ! it is simplest query I have ever found on this group. Regards, Waseem Saifi On Wed, Jul 24, 2013 at 6:51 PM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > With the help of SUM IF, you can get the result. > > For ref. PFA > > > On Wed, Jul 24,

Re: $$Excel-Macros$$ Sum query

2013-07-24 Thread Ravinder Kumar
Hi With the help of SUM IF, you can get the result. For ref. PFA On Wed, Jul 24, 2013 at 6:20 PM, suresh k wrote: > Hi All, > > I have attached my query regarding sum function query > I know this can be solved through pivot table, but I want the result in > formulaes. > Pls let me know if any