Dear ajnabe_maqbool, There were names combined with figures.
To calculate total figures of the same person, first of all we have to split the persons'name off the figures. After that we haveto make unique value for the ID number (1,2,3,4) as well as the persons' nameand make the total for each person with "SUMIF" Hope this explanations and solution meet your need. Regards, Hendrik Karnadi ________________________________ From: ajnabe_maqbool <[email protected]> To: [email protected] Sent: Tuesday, 30 October 2012, 18:54 Subject: ]] XL-mania [[ how can i calculate - &+ figure of the same person from a different columns Dear Member, I have Xell Sheet, 1 asim 50 2 maqbool -25 3 shah 65 4 javed 0 1 asim -15 2 maqbool 25 3 shah -35 4 javed -15 4 javed 10 Required For example : what is the formula: Code Name -Figure +Figure 1 Asim -15 50 2 3 4 Thanks for anybody who provide assistance [email protected] [email protected] S
Calculate total value of the same person.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
