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)
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
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
=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