COUNTIFS Volatile or Non-Volatile?

[sinspawn56]

I tried searching for this on Google and found a lot of good information regarding volatile and non-volatile formula. However, nothing that I have found stated for certain if a COUNTIFS was or was not.

Is COUNTIFS a non-volatile formula?

[jeffreybrown]

From what I understand, no

On this site you can read some more about volatility, plus, a workbook you can download to test formulas for volatile vs. non-volatile.

http://www.decisionmodels.com/calcsecretsi.htm

[FDibbins]

a regular countifS(crit-range1,crit1,crit-range2,crit2 etc) is non-volatile. a formula is only volatile if the range that it is/will reference is "adjustable" through another function

[sinspawn56]

Thank you for your input.

[FDibbins]

Interesting link Jeff, thanks

[sinspawn56]

Just another thought. Would replacing

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

be more efficient?

[jeffreybrown]

Yes.

Sumproduct was the function for pre 2007, but since you are past that version, the newly introduced Countifs is much more efficient.

[sinspawn56]

Excellent, thank you.

[dogberry]

From what I understand, no

On this site you can read some more about volatility, plus, a workbook you can download to test formulas for volatile vs. non-volatile.

http://www.decisionmodels.com/calcsecretsi.htm

Thank you for the link


Chris