Hi Jay,
What does this "--" double dash do in this formula.
Thanks
Exceltech
On Jun 2, 6:39 am, Jay wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey wrote:
>
On Jun 2, 6:39 am, Jay wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey wrote:
>
>
>
> > Hi Nidhesh,
>
> > Excellent criteria.
> > I have attached one file whi
Please check out following links.
http://www.mrexcel.com/tip083.shtml
Regards,
Mudassar Ramzan
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Monday, June 01, 2009 7:52 PM
Subject: $$Excel-Macros$$ Re: SUMIF for multiple conditions
Hi
Hi,
You can use sumproduct formula as below :
=SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
it's give the same result ...
On Jun 1, 7:52 pm, Dilip Pandey wrote:
> Hi Nidhesh,
>
> Excellent criteria.
> I have attached one file which can be of interest for you.
>
> Note:- If you need some
Hi Nidhesh,
Excellent criteria.
I have attached one file which can be of interest for you.
Note:- If you need some more examples, then please let me know.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
O
You can try Sumproduct
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Nidhesh Dhawan
Sent: 29 May 2009 02:28 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SUMIF for multiple conditions
Hi,
Can any bo
Hi Nidhesh,
I am attaching a sample file for you using sumproduct.
Here I have used two conditions:
Column A has the value of A
Column B has the value of DD
Add the values in Column C whenever both the conditions match
=SUMPRODUCTA1:A9)="A")*((B1:B9)="DD")),(C1:C9))
The same can be done
if you are using excel 2007 then you can use SUMIFS.. or otherwise use
SUMPRODUCT
Regards,
Andy
On Fri, May 29, 2009 at 3:57 PM, Nidhesh Dhawan wrote:
> Hi,
>
> Can any body help me with applying sumif formulae with multiple conditions.
>
> I have following reservations:
>
> 1) Don't want to use
