copying cell date to another sheet that meet criteria

[Lynwood]

I'm trying to take data from my check register sheet and put it in my Year to date sheet. What I need excel to do is look in the category column list for "Business Lunch in my check register and if it find it, then look at the date column for the date of the transaction and then place the amount from the withdraw column into my Year to Date sheet.
Can anyone help me on this issue? I am using excel 2011 on my MacBook.

 

[Lynwood]

I'm trying to take data from my check register sheet and put it in my Year to date sheet. What I need excel to do is look in the category column list for "Business Lunch" in my check register and if it find it, then look at the date column for the date of the transaction and then place the amount from the withdraw column into my Year to Date sheet. Also if there is more then one business lunch that month it should add them together. in this example since cell E4 is business lunch and the date is in February, then cell F4 ($60.00) from the check register should be put in cell C4 in the year to date sheet.
Can anyone help me on this issue? I am using excel 2011 on my MacBook.

Date	Transactions	Check No.	Describtion	Categories	Withdraws (-)	Deposits (+)
						Beginng Balance
1/16/24​	ACH		RENT IN	RENT IN		500.00​
1/16/24​	EFT		MY BANK	Owner's Salary	200.00​
2/13/24​	Card		Long Horns	Business Meetings	$60.00​

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

Lawn Care

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

Tools

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

Vehicle Expenses

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

Business Lunch

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​

$0.00​