counting trouble

[Jay]

I have a spreadsheet that I am trying to make count of the number of times a value from a range in column H, appears in a range of column C. So that, if 2 values entered in column H appear in a total of 3 times column C then the cell would report a 3

I have tried an extended IF statements, and the COUNTIF statements and am not getting the results I am looking for. I started trying to use VLOOKUP and could not even get it to come close

Does anyone have any Ideas that might be helpful

Feel free to email me if you would like any more information
(e-mail address removed)

Thank you for an hel you can offer.

 

[Bernie Deitrick]

Jay,

Enter this as an array formula, using Ctrl-Shift-Enter:

=SUM(COUNTIF(C:C,H1:H100))

Adjust the range H1:H100 as needed.

HTH,
Bernie
MS Excel MVP

I have a spreadsheet that I am trying to make count of the number of times

a value from a range in column H, appears in a range of column C. So that,
if 2 values entered in column H appear in a total of 3 times column C then
the cell would report a 3.

I have tried an extended IF statements, and the COUNTIF statements and am

not getting the results I am looking for. I started trying to use VLOOKUP
and could not even get it to come close.

 

[Frank Kabel]

Hi
not so sure what you're trying to achieve. Could you give an example
for both columns with your expected result

 

[Jay]

I am trying to get a column that has holiday dates in it, i.e. Mar 17, 2004 to April 1, 2004, to compare these holiday dates to a column that has a list of dates, i.e. Mar 29, 2004 to April 30, 2004
I need to be able to get a number that shows how many of the holiday dates are in the big list of dates

I hope that makes it more clear.

 

[Frank Kabel]

Hi Jay
try Bernie's formula