Hi Hylton.There is an ISBLANK() function that will test if the cell is blank. Safer might be to test IF UPPER($Data.F$3:F$1000) NOT "Y" Check the help on SUMFS also for multiple test criteria as you could test for ISBLANK(), is not "y", is not "Y"
Is there a reason you are not entering the dates as a date rather than a number.
Steve On 28/09/2018 03:24, Hylton Conacher (ZR1HPC) wrote:
I am using the formula of=IF(INT($Data.$A$3:$Data.$A$1000/100)=$A3,SUMIF($Data.F$3:F$1000,"N",$Data.C$3:C$1000),0)This formula works but I would like to have a blank field i.e. "" instead of "N".