Formula Help

Options

Hey guys,

I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market)

I thought it would be something like, but neither are working

 =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT", Type A:Type A) or =COUNTIFS(Campaign:Campaign, "Jazz", Market:Market, "AT", SUM(Statics:Statics))

we also need this as Type A, per campaign, per month

Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!