Use sumifs which is a new function in 2007. this is very easy
On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote:
>
> Can anyone provide me the formula for below query.
>
>Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
> 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
> Answer
Please see the attached file.
You'll have to do few adjustments to work it out
Joby
--- On Tue, 25/8/09, suresh k wrote:
From: suresh k
Subject: $$Excel-Macros$$ IF condition formula
To: "Excel group"
Date: Tuesday, 25 August, 2009, 5:53 PM
Can anyone provide me the formula for below q
Thanks Harmeet..!!
But, I must say that the solution provided by Paul is also good, the only
limitation which I can see in it is that It won't work in Excel 2003 / xp or
versions below than that.
Suresh.. the Brave man... if you have Excel 2007 version installed in your
PC, then please go ahead an
I think Dilip has already provided the solution.
plese refer to attached file.
On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote:
>
> Can anyone provide me the formula for below query.
>
>Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
> 7/2/2009 7.92 7/2/2009 9.02 7
Try =SUMIFS (not SUMIF, but SUMIFS)
the plural means multiple conditions!!!
the function Wizard makes it very easy to use.
But your formula becomes:
=SUMIFS(B2:B6,A2:A6,"7/2/2009",B2:B6,">8")
Sums B2-B6, if A2-A6 is "7/2/2009"
and if B2-B6 is > 8.
hope this helps.
Paul
__
Ok..I think tomorrow, we can discuss on this over Gtalk.
If you want you can draft your queries as well and sent that to the group.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 6
Hi Suresh.. the Brave man.!!
Attached workbook has the solution to your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 5:06 PM, suresh k wrote:
> Hi Dilip,
>
> Could yo
