Formula Needed

daddywine

New Member
Joined
Jun 29, 2012
Messages
2
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 ---
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,803
Messages
6,104,073
Members
447,892
Latest member
madara uchiha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top