Two formulas in one cell that subtract from each other?

[danbilon]

Hello All,

I am trying to figure out a formula for the following:

I have three tabs in an excel workbook for an accounting project: "Variance," "Actual", and "budget."

Each tab has a unique GL# in column A followed by dollar amounts in the next columns representing the month. All the tabs have the same GL#s.

In the variance tab, I want to put a formula. I want each cell next to the GL# to extract the amount from the "Actual" tab that contains the same GL, I also want to extract the amount from the "Budget" tab into the same cell. I want the extracted amount from Actual tab to subtract the amount extracted from the Budget tab.

I tried SUMIF but it can only extract me information from one tab. I need to do something like two SUMIF formulas that can also subtract one from the other.

Any ideas?

Thanks,

 

[Coding4Fun]

Something like this?

I created the 3 sheets as described, the 3 sheets are identical with GL# in column A. This formula would be inserted in column B on the Main Sheet.

=SUM(SUMIF(Actual!A:A,Variance!A2,Actual!B:B)-SUMIF(Budget!A:A,Variance!A2,Budget!B:B))