SOLVED

Help with Excel

Copper Contributor

I am working on formulating an excel sheet and want to use rep codes to label certain rows and numbers. For example, 

 

205G
305G
405M

 

I want to be able to have a formula that calculates the "G" total and then the "M" total on a different sheet. How am I able to do this? 

2 Replies
best response confirmed by admin2019 (Copper Contributor)
Solution
For each rep code, just change the "G" in the following formula:

=SUMIF(B:B,"G",A:A)

@PReagan How do I get it to Sum the total? When I do that formula it is not adding the numbers together.

1 best response

Accepted Solutions
best response confirmed by admin2019 (Copper Contributor)
Solution
For each rep code, just change the "G" in the following formula:

=SUMIF(B:B,"G",A:A)

View solution in original post