Trying to add a formula to get the count per month

Roshni Verappan

I am trying to build a formula on another form that will pull this information and be able to provide the total per month.

i.e if someone is tracking how many Opportunities that complete per month then they would add 1 in the "opportunities" column and select the month

Then on this sheet below, I would like a formula that would add the number of opportunities per month

Is this possible with a formula or is there a better way to get this information from the other tracker?

Thanks in advance for your assistance and suport.

Roshni

BullandKhmer

OK, first thing you want to do is equalize the format of your month columns... i.e. January is january, or jan, or 01 or whatever in both sheets.

Then use this formula to sum opportunities monthly

=SUMIF({month},[time period]@row,{opportunities})

This will only work in your parent rows

Roshni Verappan

Thank you very much for the help.. this worked perfectly for what I needed.

Roshni Verappan