SUMUP reporting

Marilen.Navarro103391

Hello, Hope you can help me.

I wanted to create a report where I can count CSM name in one row and the sum of their Future, 1-30 Days......

Something like this below:

I have 22 CSM names so I have 22 rows. Thank you.

Paul Newcome

Will this be done on a separate sheet from or the same sheet as the data? Either way you are going to want to look into the SUMIFS function.

=SUMIFS({Range to sum}, {CSM Name}, "Jose Rizal")

Paul Newcome

Then you are going to want to use the proper steps for creating cross sheet references and use the syntax above.

Paul Newcome

Will this be done on a separate sheet from or the same sheet as the data? Either way you are going to want to look into the SUMIFS function.

=SUMIFS({Range to sum}, {CSM Name}, "Jose Rizal")

Marilen.Navarro103391

Paul - It would be a separate sheet. Thanks.

Paul Newcome

Then you are going to want to use the proper steps for creating cross sheet references and use the syntax above.