ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 857
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I am not quite able to modify an existing formula to accommodate a new change. I need to include another matching criteria in cell value B3 (current date) while the existing one B1 is yesterday's date.
the new file now has both dates so I need to be able to obtain a figure that presents both.
VBA Code:
.Range("B5").Value = .[SUMPRODUCT(IFERROR(('NQ Ns'!$B$2:$B$2995='Ns COMPARE'!$B$1)/COUNTIFS('NQ Ns'!$B$2:$B$2995,'Ns COMPARE'!$B$1,'NQ Ns'!$A$2:$A$2995,'NQ Ns'!$A$2:$A$2995&""),0))]
the new file now has both dates so I need to be able to obtain a figure that presents both.