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