rollup formulas

steve50951

I have personnel sending out emails. I want to track how many total emails each person has sent in a given city

they put a checkbox after each email has sent. I would like a formula that would total the checked boxes from each person. is that a countif? countifs?

thanks,

SGF

Joanna Waligora

Hi,

Regarding your second graphic - what determines the city to which the checkbox applies? Is there a separate sheet for each city or maybe another dedicated column not shown in the screen grab?

In general, you should be good with the Countifs() function. Something along the lines of:

Countifs(

[Email Sent]:[Email Sent], 1,

[Email Sent By Who]:[Email Sent By Who], "Katie Elsey")

You can substitute the name with a cell reference, and include the city condition depending on your particular sheet/column configuration.

Joanna Waligora

Hi,

Regarding your second graphic - what determines the city to which the checkbox applies? Is there a separate sheet for each city or maybe another dedicated column not shown in the screen grab?

In general, you should be good with the Countifs() function. Something along the lines of:

Countifs(

[Email Sent]:[Email Sent], 1,

[Email Sent By Who]:[Email Sent By Who], "Katie Elsey")

You can substitute the name with a cell reference, and include the city condition depending on your particular sheet/column configuration.

steve50951

The cities are different sheets. This is exactly what I need. Its perfect. Thanks!

SGF