[dba-Tech] Excel formula

Assuming dates are I A1 and B1, and data top add is in A2 and B2...

Try =IF(MATCH(C1,D1,1)=1,SUM(A2,B2),"")


Jon

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Billy Pang
Sent: 20 February 2007 23:32
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Excel formula

Concatenate the values returned by MONTH and YEAR (eg. =YEAR(A5) &
MONTH(A5)) for the sumif?

Or if the datasource is sorted by date, then perhaps the subtotal by the
concatentate value mentioned above (ie. FILE --> DATA --> SUBTOTAL...)?

Billy

On 2/20/07, Susan Harkins <ssharkins at setel.com> wrote:
>
> I'm trying to use SUMIF to keep a running total of monetary values, by 
> a date value in another column. I think SUMIF's the way to go, but I'm 
> not getting it right -- I don't know how to tell the formula to use 
> just the Month component of the date.
>
> I have two columns: Date and Fee. I want to see a third column that 
> sums the values in Fee when the month and year in Date are the same.
>
> Anyone know how to do that?
>
> Susan H.
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



--
Billy Pang
http://dbnotes.blogspot.com/
"Once the game is over, the King and the pawn go back in the same box." -
Italian proverb _______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

--
This email has been verified as Virus free Virus Protection and more
available at http://www.plus.net