Sum weekly total spent for two funds

[charlierb3]

Hi I'm tracking expenses out of two funds and I'd like to know how to sum total spent each week for each fund.

I have 3 columns

Transaction | Fund | Week Number

$30.00 | Fund 1 | 2​

$41.00 | Fund 2 | 2
$50.00 | Fund 1 | 2
$70.50 | Fund 1 | 4
$80.95 | Fund 2 | 4


I'd like to add two more colums: Weekly total for Fund 1 and Weekly total for Fund 2

and need a formula that is something like "for every change in Week Number, add transactions where Fund = Fund 1"

Thanks for your help

 

[kpark91]

Hi,
I think what you're looking for is SUMIFS function.
http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010342933.aspx?CTT=1
If you want Fund 1, Week number 2 total. Use

=SUMIFS($A$1:$A$5,$B$1:$B$5,"=Fund 1", $C$1:$C$5, "=2")

 

[WinteE]

Use SUMPRODUCT()

Assuming your data is in columns A:C

=SUMPRODUCT((B:B="Fund1")*(C:C=2)*(A:A))

Success
Erik