ok i have a totals page in a spreadsheet that reads data from column N in tabs January through December that looks like this:


=COUNTIF(January!$N$:$N$500,"1")

this formula is fine cause i only need it to read the "1" but the next total formula i have needs to read if columns N have a 2 or a 3 so where it says "1" in my formula what do i put so it will add all the 2's and 3's together?