D Davel Joined Jul 30, 2018 Messages 1 Reaction score 0 Jul 30, 2018 #1 hi, i have a sheet in column A i have A,B,C,D for example then column E to AI, i have a value of H but i would only like to count the the "H" that relate to column A that has a value of A ?hope this makes sense Thanks
hi, i have a sheet in column A i have A,B,C,D for example then column E to AI, i have a value of H but i would only like to count the the "H" that relate to column A that has a value of A ?hope this makes sense Thanks
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 Jul 30, 2018 #2 Davel said: hope this makes sense Click to expand... Hmmm... Not sure I follow. You want to count the number of instances where column A has a value of "A" and the other column has a value of "H"?
Davel said: hope this makes sense Click to expand... Hmmm... Not sure I follow. You want to count the number of instances where column A has a value of "A" and the other column has a value of "H"?