How can I automate a calculation of two columns in a third column in Excel?

Sudeep June 10, 2011
Pinterest Stumbleupon Whatsapp

If I have two types of values in columns B and C and corresponding to each pair of values, the average appears in column D. Is there a way to automate the averaging process?

Screenshot:

Ads by Google