counting trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

Jay said:
I have a spreadsheet that I am trying to make count of the number of times
Click to expand...
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
Click to expand...
not getting the results I am looking for. I started trying to use VLOOKUP
and could not even get it to come close.
 
Hi
not so sure what you're trying to achieve. Could you give an example
for both columns with your expected result
 
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.
 
Back
Top