hi all
i have a table that list all my s/m and their Total sales for the year
i have another table with other totals for each s/m i would like to know the percentage of that other number compared to their total sales like (=A1/AI14) how would i get that done ?
i want it to match the s/m one the second table and find it on the first table and do the above formula
Thanks
i have a table that list all my s/m and their Total sales for the year
i have another table with other totals for each s/m i would like to know the percentage of that other number compared to their total sales like (=A1/AI14) how would i get that done ?
i want it to match the s/m one the second table and find it on the first table and do the above formula
Thanks