Excel Help

Question

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.&nbsp;

preagan · Answer

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

admin2019 · Answer

PReagan&nbsp;how will this make it transfer to other sheets?

preagan · Answer

admin2019,&nbsp;I apologize, I must have misunderstood your question. Could you please provide a sample of what you are trying to achieve?&nbsp;Thank you!PReagan

Forum Discussion

Excel Help

3 Replies

Resources