Reduce the quantity of calculations

[Boivin12]

I have a very large excel.
I have countifs that verify if something is in two categories but, there is a lot of blank cells.
I was thinking about adding sthg like : =if( cells blank ; 0 or null or something ; countifs( ))
Would it be possible, and more important, would it reduce the quantity and time of calculations ?

 

[RobP]

Hi welcome to the forum,

most things are possible in Excel in one way or another

It could reduce the time taken possibly, but hard to quantify as there is still a calculation to be done (in checking if a cell is blank).

I guess depends how many blanks versus real data you have...

Rob