Do shorter formulas affect calculation speed performance?

[Country_Calc]

I have a spreadsheet which has many +COUNTIFS, +SUMIFs in a series.

Example =COUNTIFS(A1:A100,"*Name*",B1:100,"*Title*")+COUNTIFS(A1:A100,"*Other*",B1:100,"*Other*")+COUNTIFS(A1:A100,"*Var1*",B1:100,"*Var2*")+


If I redo with something like this below, would this improve excel's ability to calculate it faster?

=SUM(COUNTIFS(A1:A100,"*Name*",B1:B100,{"*Title*","*Other*","*Var1*}))

 

[Jonmo1]

I don't think it matters if one is faster than the other, because they don't both do the same thing.

Original
=COUNTIFS(A1:A100,"*Name*",B1:B100,"*Title*")+COUNTIFS(A1:A100,"*Other*",B1:B100,"*Other*")+COUNTIFS(A1:A100,"*Var1*",B1:B100,"*Var2*")
Your attempt with the SUM(COUNTIFS syntax is doing this
=COUNTIFS(A1:A100,"*Name*",B1:B100,"*Title*")+COUNTIFS(A1:A100,"*Name*",B1:B100,"*Other*")+COUNTIFS(A1:A100,"*Name*",B1:B100,"*Var1*")


Anyway, generally speaking I don't believe the sum(countifs syntax is any faster than coutifs+countifs.
At least not the calculation speed.
It's really just a short cut to make it easier to write. It still actually performs each of the multiple countifs.


And as a rule of thumb, Shorter does not = Better. Usually, maybe, but not absolutely.
Don't let the length of a formula be the sole purpose for trying to 'fix' it.

 

[Country_Calc]

thanks for info, now I will not be fixing something that is not broken.

 

[Jonmo1]

You're welcome.