uday
Member
Hi all,
I want to calculate the sum value of the Price column in the attached file. However, the challenge is the data range in the Price column is not fixed like if I want to insert a new row the sum range should automatically change based on Item column data. Moreover the 0 and "-" are in Price column which is ignoring to a selection of the whole sum range. Please suggest.
Regards,
Uday
I want to calculate the sum value of the Price column in the attached file. However, the challenge is the data range in the Price column is not fixed like if I want to insert a new row the sum range should automatically change based on Item column data. Moreover the 0 and "-" are in Price column which is ignoring to a selection of the whole sum range. Please suggest.
Regards,
Uday