Counting number of cells that contain a certain formula

[C138759]

I am trying to count the number of RTD calls in a given worksheet. The formula that I used was =COUNTIF(A1:FF1000, "*server*"). Server is a particular word in the RTD call that is exclusive to any RTD call in my spreadsheet. The problem is that the countif function does not see formulas, it only sees that the cell is blank (if macros not enabled) or that the cell has the value off the server (if macros are enabled). How can I get excel to consider formulas programmed into each cell, not the actual displayed value?

if I can't do it that way, is there a way I can literally tell excel, count this cell if it is an RTD call?

Thank you so much for any help!

[Kenneth Hobson]

Welcome to the forum!

I don't know what RTD means.

Please Login or Register  to view this content.

[C138759]

Kenneth - Thank you so much!

RTD is real time data. RTD calls pulls data off a server into the spreadsheet.