Thread
:
Countif - Countif
View Single Post
#
4
Don Guillett
Posts: n/a
Why don't you give us your layout and the problem and the desired solution.
It's possible that a =sumproduct((rnga="joe")*(rngb=1)) would be your answer
--
Don Guillett
SalesAid Software
"maswinney" wrote in message
...
I understand the COUNTIF formula, but how can I subtract the results of
a column from the COUNTIF results of another column? Or can I?
For instance, if my first COUNTIF formula gives me 63 in column A, how
do I subtract the results of column B, which also contains a COUNTIF
formula that equals 14.
--
maswinney
------------------------------------------------------------------------
maswinney's Profile:
http://www.excelforum.com/member.php...o&userid=16497
View this thread:
http://www.excelforum.com/showthread...hreadid=278760
Reply With Quote