Excel Help

[admin2019]

How do you connect information from one sheet to another? I have been using the formula SUMIF(A:A, "M", B:B) to find the sum of information for rows represented with "M". Is there a formula for me to transfer the information for rows labeled "M" or "G"? I want to arrange the information to divide the codes up to different sheets automatically without having to manually put in the information. 

[#2]

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

[#3]

@PReagan how will this make it transfer to other sheets?

[#4]

@admin2019,

I apologize, I must have misunderstood your question. Could you please provide a sample of what you are trying to achieve?

Thank you!

PReagan