templates - Google Spreadsheet function for email tracking -

templates - Google Spreadsheet function for email tracking -

i trying larn how create functions in google spreadsheet using track success rate of template emails. here example.

what functions 'template tracking' sheet in c2, d2 , e2?

essentially if value exists in 'email tracking' column d count (if nil there, don't) , create sum in appropriate place on 'template tracking' sheet based on 'template #' in 'email tracking' column c.

while still no conclusion function, did find using pivot tables easy workaround.

can see how looks here.

welcome farther ideas function hope helpful others might want utilize it.

email templates spreadsheet tracking