$$Excel-Macros$$ Sum query

2013-07-24 Thread suresh k
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 anyone can solve this? /Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

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 brave.sur...@gmail.com 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

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, 2013 at

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 brave.sur...@gmail.com To: Excel group excel-macros@googlegroups.com Sent: Wednesday, July 24, 2013 6:20 PM Subject: $$Excel-Macros$$ Sum query Hi All, I have attached my query regarding