Thanks Ankur
On Wed, Jul 20, 2011 at 7:19 PM, ankur wrote:
> hi kaushik
> plz use this formula
> =SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0))
> sample file is attached for ur reference
>
>
> On 20/07/2011, Aindril De wrote:
>> Hi Kaushik,
>>
>> The criteria that you hav
hi kaushik
plz use this formula
=SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0))
sample file is attached for ur reference
On 20/07/2011, Aindril De wrote:
> Hi Kaushik,
>
> The criteria that you have mentioned is not clear enough. Please clarify the
> critera properly.
> Do
Hi Kaushik,
The criteria that you have mentioned is not clear enough. Please clarify the
critera properly.
Do you mean it would sum is all the criteria is met or sum only the cells
that meet the criteria.
Cheers,
Andy
On Wed, Jul 20, 2011 at 1:15 AM, kaushik modak
wrote:
> Hello Guys,
>
> Pleas
Hi,
Without your file, I can't test this, but the XL did accept the following as a
valid formula:
=SUMIFS('1-Diary'!$H$9:$H9954,'1-Diary'!$B$9:$B9954," Date: Tue, 3 May 2011 05:47:53 -0700
> Subject: $$Excel-Macros$$ SUMIFS
> From: gmccaff...@acutus.co.uk
> To: excel-macros@googlegroups.com
>
Thanks Ashish
On 20/02/2011, ashish koul wrote:
> see it it helps
>
> On Sun, Feb 20, 2011 at 3:10 AM, sudhir kumar wrote:
>
>> HI
>> All Dear Friends,
>>
>> Please help on attached file.
>>
>> thanking you
>>
>> Regards
>> Sudhir Verma
>>
>> --
see it it helps
On Sun, Feb 20, 2011 at 3:10 AM, sudhir kumar wrote:
> HI
> All Dear Friends,
>
> Please help on attached file.
>
> thanking you
>
> Regards
> Sudhir Verma
>
>
>
> --
Kindly attach the XL
On Jan 20, 10:53 am, Manoj kumar
wrote:
> please send us an attachment..
>
> Regards,
> Manoj Kumar
>
>
>
>
>
>
>
> On Thu, Jan 20, 2011 at 9:51 AM, solsbee wrote:
> > I am doing a data dump into and excel spreadsheet and the date format
> > that I get is MMDD. I am try
please send us an attachment..
Regards,
Manoj Kumar
On Thu, Jan 20, 2011 at 9:51 AM, solsbee wrote:
> I am doing a data dump into and excel spreadsheet and the date format
> that I get is MMDD. I am trying to sum the data by two criteria
> using the sumifs function, but I keep getting an
