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?
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?
Last edited by sinspawn56; 12-25-2012 at 11:23 AM.
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
Last edited by jeffreybrown; 12-25-2012 at 11:22 AM.
HTH
Regards, Jeff
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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for your input.
Interesting link Jeff, thanks
Just another thought. Would replacing
With![]()
Please Login or Register to view this content.
be more efficient?![]()
Please Login or Register to view this content.
Yes.
Sumproduct was the function for pre 2007, but since you are past that version, the newly introduced Countifs is much more efficient.
Excellent, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks