Formula Needed

[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 in the first screenshot that would check column A of the worksheet in the second screenshot for a date that matches cell B4 of the worksheet in the first screenshot. If the dates match I would like it to sum any amounts in column G of the worksheet in the second screenshot. I say sum because sometimes there would just be on 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 second screenshot.


-- removed inline image ---



-- removed inline image ---

 

[Michael M]

Hi and welcome to the board
Best try again...that didn't work.
Use the HTML maker in my tag to upload data to this forum.

 

[daddywine]

Thank you Michael!

I've tried your HTML maker. I had no problem installing it but when I ran it I got the following VBA error:
Run-time error '53':
File not found: user 32.dll

I should note that I am running a Excel for Mac 2011 on a Mac with OS 10.6.8.

When I tried to debug it highlights:
Open Clipboard (0)

Thanks in advance for your help,
Sonny

 

[Michael M]

Yeah, probably 'cause it's a Mac.....but I can't offer any advice whatsoever for Mac users.
Hopefully someone else can step in to advise.