Help me with this.

I want to total all score that has Cell A=STUD but Cell B=A, and also A=MAN but B=C.

can you give me the formula for this I really appreciate your help guys.

A B C

STUD A 2

MAN C 3

STUD A 5

STUD A 10

To get Total of STUD A

=SUMIF(A1:A100,"=STUD",C1:C100)To get Total of MAN C

=SUMIF(A1:A100,"=MAN",C1:C100)Change A1:A100 and C1:C100 as per your data.

sylink, First, when posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Excel Formulas" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Second, if you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done.

Thanks!

DerbyDad03

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

If I understand your question correctly, you want to SUM Column C based on 2 conditions: SUM of STUD in Column A but only when the corresponding cell in Column B = A.

If that if correct, the solution depends on the version of Excel that you are using.

For Excel 2007 and beyond try:

=SUMIFS(C1:C4,A1:A4,"=STUD",B1:B4,"=A")

For all versions, older and newer, this should work:

=SUMPRODUCT((A1:A4="STUD")*(B1:B4="A")*(C1:C4))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thanks for you for answer it help a lot for me.

Sorry for the subject line and thanks for changing my subject line.

Ask Your Question

Weekly Poll

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History