Forum Discussion

BecKry's avatar
BecKry
Copper Contributor
Jul 07, 2023

Formula help

Can anyone help.... i need to create a formula to show the total number of those with 2022, 2023 or blank. Im assuming an IF formula but cant work it out    
  • Patrick2788's avatar
    Patrick2788
    Jul 07, 2023

    BecKry 

    Try this one:

    =SUM(COUNTIF(J2:J16,{2022,2023,""}))