Sumifs

Hi,

Need some help with a SUMIFS formula. I’m getting really confused.

I have a range of subject email lines used (column D) and the dates (column C) that they were sent.

I want excel to group together all the same subject lines and same dates and to sum up the number of clicks for that respective date (Column G) and divide it by sales (Column K) and have it appear under column L as Conversions.

I should mention that the number of sales is for the total of that days and not for each specific subject line. So for example, lets say we have 2 sales, that 2 sales represents all sales for that particular subject line used on that date.

Basically I want to find out the conversion of a particular subject line used for a specific date in terms of sales/clicks.

I've tried reading the excel help files but I still can’t get it to work.

Take a look at the attached sheet. Also, I had a similar post up a couple of weeks ago, but created a new post because the situation is a little different.

Thank you so much.