First, I apologize if my use of quotations and such are not correct. I will try my best to explain my situation and I appreciate any help provided.
I have one Workbook with multiple sheets.
Sheets are titled, "This Month" "Last Month" and "Compiled Data".
The rows of data on "This Month" and "Last Month!" do not match.
For example on "This Month" the information in Row 26 (1420576) does not appear at all on "Last Month".
Sometimes the reverse is true. The information is on "Last Month" and not on "This Month". For example, Row 68(1608785) is on "Last Month" but not "This Month".
I need to add the information from Column O from "This Month" to the information from Column O on "Last Month" and I want that information to insert into Column H on the "Compiled Data" sheet.
I have tried to use =sum('This Month'!$O$2)+('Last Month'!$O$2) but that doesn't account for the information that is different between the rows from each sheet.
How can I use a formula or something to complete this task without manually comparing each row?
Here is an example sheet to reference.