sum a value of column based on the value of other columns
I am new to unix and use it rarely...need yor help..
i have csv file:
need to sum the values of col5 based on values in col3 and col4 as Y.....commas in double quotes are not considered as delimiter.
explanation----> 20.8(one time Y in row 1 col3)+179.2(one time Y in row 2 col4)+30*2(two times Y in row 3 in both col 3 n 4)=260
Last edited by umix; 10-16-2012 at 09:03 AM.