making the range a set of data within a column
 

I have a column with different sets of values. On another worksheet I want
to to make a formula using COUNTIF that states how many times a value from
another column in the first sheet appears when a given value is set.

Example.

In the first sheet in column 1 the number 554 appears 10 times. In another
column the values corresponding are in a range of 1-4. On another sheet, I
want to do a COUNTIF where the range selected is 554 on the first sheet.

So you'd want to know the count of rows that have 554 in column A and 3 (say) in
column B?

if yes:

=sumproduct(--(a1:a99=554),--(b1:b99=3))

=sumproduct likes to work with numbers. the -- converts trues and falses to 1's
and 0's.



RFKFREAK wrote:

I have a column with different sets of values. On another worksheet I want
to to make a formula using COUNTIF that states how many times a value from
another column in the first sheet appears when a given value is set.

Example.

In the first sheet in column 1 the number 554 appears 10 times. In another
column the values corresponding are in a range of 1-4. On another sheet, I
want to do a COUNTIF where the range selected is 554 on the first sheet.

--

Dave Peterson