I have2 columns "G" & "H"
I need to do a calculation counting the amount of rows that the figure in g is the same in h for each row.
I hope this is enough information.
I have2 columns "G" & "H"
I need to do a calculation counting the amount of rows that the figure in g is the same in h for each row.
I hope this is enough information.
try out sumproduct, do a search on that
put following function in cell I1Originally Posted by XCESIV
=AND(ISERROR(MATCH(H1,G:G,0)),ISERROR(MATCH(G1,H:H,0))) and copy it downwards to the extent you have data in col G & H (upto maximum rows). it will return FALSE if value is in both cells and TRUE if value is not in both cells.
at the end of this column (col I) put following function to count FALSE appeating in col I
=COUNTIF(I1:I100,"False") it will give you number of values which are in both columns.
hopfully this would help you
Regards
if you only want to count the figures in col G which are in col H as well then use this function.
=ISERROR(MATCH(G1,H:H ,0))
and use COUNTIF function at the end in the same way as mentioned in my previous post.
If you just want to match in the specific row
either
=SUM(IF(G5:G10=H5:H10,1,0)) entered as an array shft ctrl enter
or =SUMPRODUCT((G5:G10=H5:H10)*1)
Regards
Dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks