Remember Me?

#1
November 15th 04, 09:30 PM
 maswinney Posts: n/a
Countif - Countif

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

#2
November 15th 04, 09:39 PM
 wmjenner Posts: n/a

5 1
6 2
7 3
8 4
9
10

2 4

Not sure if this is what you mean, but the last row in each column is
the sum of the countif. Column A adds up to 6 but, since you said you
wanted to subtract the countif of Col. B, 2 is the net answer. If you
want to see the result of both, put the subtraction in a separate
cell.

If you want the 2 to be the answer, then =countif(\$a\$1:\$a\$6,"0")-b8.
The formula in b8 is simply =countif(\$b\$1:\$b\$6,"").

--
wmjenner

------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282

#3
November 15th 04, 10:14 PM
 KL Posts: n/a

maswinney,

What end result are you trying to achieve?

KL

"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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM terryv Excel Worksheet Functions 2 November 8th 04 09:03 AM reno Excel Worksheet Functions 5 November 5th 04 12:20 PM Angel160 Excel Worksheet Functions 2 November 3rd 04 05:23 PM Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM

All times are GMT +1. The time now is 09:20 PM.