Forum Discussion
Countifs - cell is a result of a formula
Hello, I am trying to use countifs , however part of my count is using the result of an equation. the result is a date based on a formula of a start date + 45 days. the result cell is converted...
in addition the formula : = COUNTIFS($F$1:$F$474,$I29,$G$1:$G$474,T$28) where G$1:G$474 is a date based on a formula result
Select column G and set the number format to General. You'll see numbers.
Are they whole numbers like 45001, or do they (or at least some of them) contain a fractional part, for example 45001.929?
(You can press Ctrl+Z to restore the original format)
- Gives a whole number when converting to general.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar see picture below:
The red circle month is a formula result of the date in red box + 45 days. (formatted to month)
The countifs statement is looking at that cell. as you can see the count box says 0 (when there is at least 1 for July)
hope this helps