Excel 2007 help..

[Ace Modder]

Hi have the following spreadsheet, this is a data LUA extract I have made using the following code

floor = math.floor;
function GetDifficultyColor() return {r = 1.0, g = 1.0, b = 1.0} end

loadfile("MobInfo2.lua")();
loadfile("MobInfo2/MobInfo2.lua")();
loadfile("MobInfo2/MI2_Health.lua")();
loadfile("MobInfo2/MI2_ConvDropRate.lua")();

columns = { "name", "level", "healthMax", "kills", "loots" };
io.output("data.csv");
for i, v in ipairs(columns) do io.write(v .. ";"); end
io.write("\n");

for key,v in pairs(MobInfoDB) do
	local name, level = string.match(key, "^(.-):(.-)$");
	local data;
	local kills = 0;
	for _, user in pairs(MI2_CharTable) do
		MI2_PlayerName = user;
		data = MI2_GetMobData(name, level);
		if data then
			if type(data.kills) == "number" then kills = kills + data.kills; end
			data.kills = kills;
		end
	end
	if data then	
		io.write(name .. ";" .. level .. ";");
		data.loots = data.loots or 0;
		for i = 3, #columns do io.write(tostring(data[columns[i]]) .. ";"); end
		io.write("\n");
	end
end

But I wanna convert the spreadsheet to total all mobs the same name but different lvls into a single kill total? Any ideas how this could be done using a formula or something in excel.

Thanks