manuelphilippe
New Member
- Joined
- Dec 29, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- MacOS
I am having an issue. I'm getting a VALUE error. Let me fill you in on the details.
- I am summarizing some budgetary info. I'm using SUMIFS to calculate the sum of my amount column and putting the result in another sheet.
- The sums are being filtered by month based on date.
- The issue I'm having is when the date cell is blank, my formula produces a #VALUE! error if it detects blank cells.
- I have a header on row 1. I'd like to calculate my formula using the entire column except for row 1 as the user may enter data that currently isn't in the sheet. I'd like to have them be able to do that without having to always update the formula.
How should I go about this? If more info is needed, please let me know.
- I am summarizing some budgetary info. I'm using SUMIFS to calculate the sum of my amount column and putting the result in another sheet.
- The sums are being filtered by month based on date.
- The issue I'm having is when the date cell is blank, my formula produces a #VALUE! error if it detects blank cells.
- I have a header on row 1. I'd like to calculate my formula using the entire column except for row 1 as the user may enter data that currently isn't in the sheet. I'd like to have them be able to do that without having to always update the formula.
How should I go about this? If more info is needed, please let me know.