Re: $$Excel-Macros$$ SUMIFS

2011-07-20 Thread kaushik modak
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

Re: $$Excel-Macros$$ SUMIFS

2011-07-20 Thread ankur
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

Re: $$Excel-Macros$$ SUMIFS

2011-07-19 Thread Aindril De
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

$$Excel-Macros$$ SUMIFS

2011-07-19 Thread kaushik modak
Hello Guys, Please help me to get to result in the attached. I have tried with sumifs, if etc., but not getting the accurate result. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITT

RE: $$Excel-Macros$$ SUMIFS

2011-05-03 Thread Dave Bonallack
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

$$Excel-Macros$$ SUMIFS

2011-05-03 Thread Gerry
Dear Experts I want to insert the NOW() or TODAY() expression into formula below instead of the 40666 value. However, it wont work when I do it. I've tried a number of different syntax and cannot seem to get it. =SUMIFS('1-DIARY'!$H$9:$H9954,'1-DIARY'!$B$9:$B9954,"< 40666",'1- DIARY'!$J$9:$J99

Re: $$Excel-Macros$$ sumifs formula doesn't work

2011-02-20 Thread sudhir kumar
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 >> >> --

Re: $$Excel-Macros$$ sumifs formula doesn't work

2011-02-19 Thread ashish koul
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 > > > > --

$$Excel-Macros$$ sumifs formula doesn't work

2011-02-19 Thread sudhir kumar
HI All Dear Friends, Please help on attached file. thanking you Regards Sudhir Verma -- -- Some impor

Re: $$Excel-Macros$$ Sumifs and date formatting

2011-01-20 Thread saggi
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

Re: $$Excel-Macros$$ Sumifs and date formatting

2011-01-19 Thread Manoj kumar
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

$$Excel-Macros$$ Sumifs and date formatting

2011-01-19 Thread solsbee
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 answer of zero, when I know that is not the correct total. I changed the date format, but still get the same a