Excel Formulas to Sum Based On Conditions

January 15, 2012 at 02:21:21
Specs: Windows XP
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


See More: Excel Formulas to Sum Based On Conditions

Report •

#1
January 15, 2012 at 03:47:42

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.


Report •

#2
January 15, 2012 at 08:17:06
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.


Report •

#3
January 15, 2012 at 08:31:31
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.


Report •

Related Solutions

#4
January 15, 2012 at 19:04:28
Thanks for you for answer it help a lot for me.
Sorry for the subject line and thanks for changing my subject line.

Report •

Ask Question