You have a workbook with sheets from January through Decemberthat stores your expenses. The best formula to calculate the Rent(entered into C5 consistently across your sheets) between April andAugust is to:
|
=SUM(April!C5+August!C5) |
||
|
=SUM(April!C5+May!C5+…+August!C5) |
||
|
=SUM(April:August!C5) |
||
|
=SUM(April:August?C5) |
Expert Answer
Answer to You have a workbook with sheets from January through December that stores your expenses. The best formula to calculate t…