Sigma formula

[UhhNegative]

Hello,

I am trying to find a sum for a formula for a range of cells. See my attached file. In the yellow box on the right I want to find the calories, fat, carb, protein for each meal. For example, for the calories I would need to do K3/E3*G3 but then I need to sum this all the way down to an arbitrary number (however big my list of foods becomes). So I basically need to SUM(K/E*G) from 3:100 (or whatever ending number). I am not sure of the notation of how to do this. In mathmatics it is easy to do with a sigma notation formula but I don't think you can use sigma in excel with writing a macro or something for it. Thank you for your help. Let me know if this makes sense or if I need to clear something up.

I know a way I could do this by making another 24 columns hidden off to the right and then summing those up but that is time consuming and there must be a way to skip that step.

I've tried SUM( (K3:K100)/(E3:E100)(G3*G100) ) but this simply adds the column values up first and then does the multiplication and division. I need it do the multiplication and divisions on a case by case basis and then add all of those numbers up.

edit: I need to do (K3/E3*G3)+(K4/E4*G4)+.... etc.

[UhhNegative]

Nevermind, I figured it out. The formula I posted works if you do the ctrl+shift+enter method. Apparently this changes it to array or something like that. Either way, it works now.