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    
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Jul 07, 2023

    BecKry 

    Try this one:

    =SUM(COUNTIF(J2:J16,{2022,2023,""}))
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jul 07, 2023
Your question is quite unclear. Explain little more and show your desired output.

Resources