Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I need some assistance with a formula that I have been working on. Here is
the formula: =COUNTIF(Agent1!D28,"100") I have gotten the formula above to work when the number "100" was manually entered into the cell. The problem that I am having now is that I have a formula in cell D28 (=C28/B28) so my count does not recognize it as the number 100 even though the cell displays 100% Not sure if the problem is with the cell contents being a formula or if it does not recognize 100% as the number 100. Any help would be greatly appreciated. V |