SHEET SUMMARY FORMULA

Marilen.Navarro103391

Hello,

I need to build a sheet summary (report) for all the sum of the table below.

I want to show on my Dashboard a Summary of each Status (In Progress etc....for each month... for Jose and Karlo and 5 more not included in my screen capture.

Can you help me? Thanks.

Genevieve P.

Hi @Marilen.Navarro103391

You can use a SUMIF function to do this! Here's an example of looking for the total numbers of the status "In Progress" across all users, just for the month of May:

=SUMIF([Associate/Category]:[Associate/Category], "In Progress", May:May)

Then to find it for June, update the formula to have a different Sum Range at the end of the formula:

=SUMIF([Associate/Category]:[Associate/Category], "In Progress", June:June)

To adjust the criteria or category that it's searching for, update the words in quotes:

=SUMIF([Associate/Category]:[Associate/Category], "Pending", May:May)

Does that make sense? Once you've set this up in your Sheet Summary fields (one field per-formula), you can then run a Sheet Summary Report using these fields. Let me know if I've misunderstood what you're looking to do or if you have any more questions!

Cheers,

Genevieve

Genevieve P.

Hi @Marilen.Navarro103391

You can use a SUMIF function to do this! Here's an example of looking for the total numbers of the status "In Progress" across all users, just for the month of May:

=SUMIF([Associate/Category]:[Associate/Category], "In Progress", May:May)

Then to find it for June, update the formula to have a different Sum Range at the end of the formula:

=SUMIF([Associate/Category]:[Associate/Category], "In Progress", June:June)

To adjust the criteria or category that it's searching for, update the words in quotes:

=SUMIF([Associate/Category]:[Associate/Category], "Pending", May:May)

Does that make sense? Once you've set this up in your Sheet Summary fields (one field per-formula), you can then run a Sheet Summary Report using these fields. Let me know if I've misunderstood what you're looking to do or if you have any more questions!

Cheers,

Genevieve