Sumif

[Smoakstack]

Looking for a way to link two worksheets together.

Financial calender and am trying to link using this formula

=SUMIF(Expense!B4:B613,MONTH(Expense!B4:B500) = 6,Expense!C4:C613)

this is for month of June. Expense worksheet looks like this

Excel Workbook
	A	B	C	D	E	F
1	Expenses
2
3	Name	Date	Amount	Type		Month
4	McDonalds	6/6/11	$2.14	Dining Out		6
5
6
7
Expense

What I want is to be able to put any date and amount on this sheet and it tallys the amount on another sheet for the month given

 

[T. Valko]

Looking for a way to link two worksheets together.

Financial calender and am trying to link using this formula

=SUMIF(Expense!B4:B613,MONTH(Expense!B4:B500) = 6,Expense!C4:C613)

this is for month of June. Expense worksheet looks like this

Excel Workbook
	A	B	C	D	E	F
1	Expenses
2
3	Name	Date	Amount	Type		Month
4	McDonalds	6/6/11	$2.14	Dining Out		6
5
6
7
Expense

What I want is to be able to put any date and amount on this sheet and it tallys the amount on another sheet for the month given

Maybe something like this...

=SUMPRODUCT(--(MONTH(Expense!B4:B613)=6),Expense!C4:C613)

 

[Smoakstack]

Works like a charm. Thank you!

Have not used that function much

 

[Smoakstack]

reason as to why I used the sumif is because thee would be more. I am looking to sum all of the positive numbers, and sum all of the negative numbers to find a total. Seeing your formula, I cannot think of a way as I have not used it much. Any help would be much appreciated.

 

[T. Valko]

reason as to why I used the sumif is because thee would be more. I am looking to sum all of the positive numbers, and sum all of the negative numbers to find a total. Seeing your formula, I cannot think of a way as I have not used it much. Any help would be much appreciated.

Try these...

Assuming you still want to use the month criteria.

To sum the negative numbers only:

=SUMPRODUCT(--(MONTH(Expense!B4:B613)=6),--(Expense!C4:C613<0),Expense!C4:C613)

To sum the positive numbers only:

=SUMPRODUCT(--(MONTH(Expense!B4:B613)=6),--(Expense!C4:C613>0),Expense!C4:C613)

 

[Smoakstack]

Works wonderfully. Thank you soo much.

 

[T. Valko]

Works wonderfully. Thank you soo much.

You're welcome. Thanks for the feedback!