Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
I need to pull the amount from the Expenses tab onto the Income Statement if the correct expense category is selected from the dropdown on
I need to pull the amount from the Expenses tab onto the Income Statement if the correct expense category is selected from the dropdown on the Expense tab, and have it apply to the correct month. I believe I have the equation correct (SUMPRODUCT/SUMIFS), but it is not pulling the amount from the expense sheet. Is there something missing from my equation? The two criteria are the expense category (i.e. "Total Paycheck Deductions") and the month ("Jan). The cell for the equation is B12.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678f226eed23_3426678f226c3cf4.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678f2277f640_3436678f2274fe46.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started