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".
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
