Shortening a formula.

Hello, I would like to know if there is a way to shorten this formula. All I am doing is adding up specific cells that contain the number 1 and getting a total count.

=SUM(COUNTIF(C3,"1"),COUNTIF(N3,"1"),COUNTIF(Y3,"1"),COUNTIF(AJ3,"1"),COUNTIF(AU3,"1"),COUNTIF(BF3,"1"),COUNTIF(BQ3,"1"),COUNTIF(CB3,"1"),COUNTIF(CM3,"1"),COUNTIF(CX3,"1"),COUNTIF(DI3,"1"),COUNTIF(DT3,"1"),COUNTIF(EE3,"1"),COUNTIF(EP3,"1"),COUNTIF(FA3,"1"),COUNTIF(FL3,"1"),COUNTIF(FW3,"1"),COUNTIF(GH3,"1"),COUNTIF(GS3,"1"),COUNTIF(HD3,"1"),COUNTIF(HO3,"1"),COUNTIF(HZ3,"1"),COUNTIF(IK3,"1"),COUNTIF(IV3,"1"),COUNTIF(JG3,"1"),COUNTIF(JR3,"1"),COUNTIF(KC3,"1"),COUNTIF(KN3,"1"),COUNTIF(KY3,"1"),COUNTIF(LJ3,"1"),COUNTIF(LU3,"1"))

Thanks!

Yes, my current formula does give the right answer, I was wondering if there is just a way to shorten it. I can't use a range of cells C3:LU3 because there will be some 1's in other cells that I do not want to count. I am looking for the text "1" as I want to total up how many times it shows up in certain cells.
for instances
Jan1 Jan2 etc...
late sick late sick
1 1 1

for all the late's, I want to count how many times a 1 shows up for the month. So I am selecting all of the cells under late and doing the countif.

Hope that makes sense.

I don't think I am explaining myself very well, I have attached a file as an example.

I am trying to calculate all the Late's that have a number 1.

So with my current formula I am doing a countif and selecting A3, C3, E3, G3, I3 to get the sum.

If I do a range, A3:J3, will it not pick up the 1's that are in the Sick's as well?

Hi cle12000, benishiryo's solution in post#2 is handling that (with MOD function that take cares of your every 11th columns starting from column 3).
Had you tried the formula? Or you had tried but not getting same result as your original formula?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Yeah, it's not giving me the right answer for some reason. I'll just leave it the way it is with the long formula, thanks for helping.

I saw different criteria in post#1 vs post#6
You're welcome, and come back anytime if you have questions



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

I do have to give props turned out it worked. Thanks a lot for your help everyone.