Sum of total from other worksheet with that meets one criteria

  • Thread starter Thread starter Excel Sum function with IF
  • Start date Start date
E

Excel Sum function with IF

I am trying to figure out how to add all dollars amounts in other worksheet
under same team ID...for instance, there are 100 different team ID but there
are some same Team ID. I want to add all values under the same Team ID. I
don't want to sort the Team ID then do sum every time. I want to be able to
type in data without having to sort it and update the function in other
sheet. How do I do that?
 
Try this:

=SUMIF(A1:A100,"team ID",B1:B100)

Better to use a cell to hold the criteria:

D1 = team ID

=SUMIF(A1:A100,D1,B1:B100)

--
Biff
Microsoft Excel MVP


"Excel Sum function with IF" <Excel Sum function with
(e-mail address removed)> wrote in message
news:[email protected]...
 
Hi Dear

Try this

=SUMIF(A1:A10,"=TeamA",B1:B10)

Column A has Team Names
Column B has amounts

If this post helps click Yes
 
I mean...I want to add all values (in column C) in other worksheet under
specific Team ID in Column A into other worksheet

I think there is sumif involved like sum of values under column C only if
column A equals 3 (team id) then put result in other sheet.
 
Hy,
try
=sumproduct(--(A1=Sheet2!A:A),--Sheet2!C:C)

I assumed your summary is in sheet 1 team information starting in A1 and the
information you want to summarize is in sheet2
 
Try this

=SUMIF([Book1]Sheet1!A1:A10,"=TeamA",[Book1]Sheet1!B1:B10)

Column A has Team Names
Column B has amounts

If this post helps click Yes
 
Hi,

nothing wrong with Biff suggestion, just change the references

=SUMIF(Sheet2!A1:A100,"team ID",Sheet2!C1:C100)

if the team id is in A1 of Sheet1 then

=SUMIF(Sheet2!A1:A100,A1,Sheet2!C1:C100)
 
If that sending workbook (book1) is closed, then this formula will return an
error.

Jacob said:
Try this

=SUMIF([Book1]Sheet1!A1:A10,"=TeamA",[Book1]Sheet1!B1:B10)

Column A has Team Names
Column B has amounts

If this post helps click Yes
Click to expand...
 
Hi Dear specialist,

Kindly help me for "SUMIF" whenI have as below ;

Col A : Name
Col B : Name OR Num
Col C : Amount

I need to get sum of total from Col C if Cols "A" and "B" are combined?
Thanks in advance
 
Many thanks Dear,

I meant when i want to refer both of criteria of Col A and col B for example;

Col A : Profit and ...
Col B : 2008 and ....
Col C : profit in 2008 "14000 $" and....

Now needs to get SUMIF(A1:B10,"Profit"and"2008",C1:C10)
refer to 14000$
can we use it as above?

look forward to
Habib
 
Back
Top