Countifs - cell is a result of a formula

Question

Hello,&nbsp;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 to a date.The countifs is not counting this resulting date ... is this because of formula?How would I be bale to count the resulting date (month).

peterc007 · Answer

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

hansvogelaar · Answer

PeterC007&nbsp;
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)

peterc007 · Answer

Gives a whole number when converting to general.

hansvogelaar · Answer

PeterC007&nbsp;
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?

peterc007 · Answer

HansVogelaar&nbsp; see picture below:&nbsp;The red circle month is a formula result of the date in red box + 45 days. (formatted to month)The countifs statement&nbsp; is looking at that cell. as you can see the count box says 0 (when there is at least 1 for July)&nbsp;&nbsp;hope this helps&nbsp;

Forum Discussion

Countifs - cell is a result of a formula

9 Replies

Resources