Match dates in column B with column A across worksheets and sum any amounts in column G

[daddywine]

Hello and thank you in advance!

I have a desire that is more complex then I have been able to solve on my own. I've searched the forum and apologize if I missed any post that already answers.

What I am trying to do is to put a formula in cell AC4 of the worksheet Sonny_s Daily Sales would check column A of the worksheet Sonny_s Invoices for a date that matches cell B4 of the worksheet Sonny_s Daily Sales. If the dates match I would like it to sum any amounts in column G of the worksheet in the worksheet Sonny_s Invoices. I say sum because sometimes there would just be one matching row in the second worksheet but other times there can be more than one row as can be seen for the date 28-Jun in the worksheet Sonny_s Invoices.

THe actual spreadsheet is attached below. This formula will be copied down through the worksheet Sonny_s Daily Sales and also copied to the other *_Daily Sales Worksheets.
June 2012 Daily Sales Report.xls

[TMS]

Look at SUMIF or possibly SUMIFS if you have multiple conditions. If you have multiple conditions and your version of Excel doesn't support SUMIFS, use SUMPRODUCT.

regards, TMS

[daddywine]

Hello and thank you TMS.

I have looked at those formula arguments and cannot figure out how I could use them for this situation. If you wouldn't mind giving me an example I would greatly appreciate it.

Thanking you in advance,
Sonny

[TMS]

=SUMIF('Sonny_s Invoices'!A:A,B4,'Sonny_s Invoices'!G:G)

Regards, TMS

[TMS]

The syntax for the SumIf function is:

SumIf( range, criteria, sum_range )

range is the range of cells that you want to apply the criteria against.

criteria is used to determine which cells to add.

sum_range are the cells to sum.

[TMS]

Thanks for the rep. Glad that I could help.

Regards, TMS