G
Guest
I have two columns of data:
Col A1:A200 are Distances (not all cells have values in them)
Col B1:B200 are Values associated with each Distance, but some Values are
positive and some are Negative
I have been successful in calculating the Frequency of the various values
within each Distance Bin (col C1:C10)
I need two more columns contiguous to the Distance Bin showing:
Sum of positive values for each frequency in the Bin
Sum of Negative Values for each frequency in the Bin
I tried:
{=SUM(IF(FREQUENCY(MATCH(A1:A200,C1:C10,1),MATCH(B1:B200:C1:C10,1))>0,""))}
for the positive Column, but get #NA
I would greatly appreciate any help and assistance.
Col A1:A200 are Distances (not all cells have values in them)
Col B1:B200 are Values associated with each Distance, but some Values are
positive and some are Negative
I have been successful in calculating the Frequency of the various values
within each Distance Bin (col C1:C10)
I need two more columns contiguous to the Distance Bin showing:
Sum of positive values for each frequency in the Bin
Sum of Negative Values for each frequency in the Bin
I tried:
{=SUM(IF(FREQUENCY(MATCH(A1:A200,C1:C10,1),MATCH(B1:B200:C1:C10,1))>0,""))}
for the positive Column, but get #NA
I would greatly appreciate any help and assistance.