Sum If Meets Criteria

  • Thread starter Thread starter halem2
  • Start date Start date
H

halem2

Hi:

let's say I have the following

10
5
7
3
10
12
40
10
18
10
5
7
11

How can I have a summation done base on criteria? Meaning, if th
number is = 10 then sum all cells that = 10 and place the resul
below.

thanks in advance for any guidanc
 
Examples and variants

=SUMIF(A1:A30,10)
=SUMIF(A1:A30,"=10")
=SUMIF(A1:A30,">10")
=SUMIF(A1:A30,"<10")
=SUMIF(A1:A30,">=10")
 
=SUMIF(A1:A20,">20"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sorry hit the button too soon, meant

=SUMIF(A1:A20,"=10")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Bob Phillips said:
=SUMIF(A1:A20,">20"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
thanks for the help. One more question.

if instead of having a colum, lets say I have 4 columns and every tim
a cell in column 1 equals a specific value (such as 10), I need to ad
a summation at th bottom of the colum PLUS a summation to the right o
the 4 colums adding up all cells in that row. Let me clarify



10-----20------13-------67--------sum here = 110
12-----7--------44-------92
10-----40------30-------80--------sum here = 160
33-----54------1---------90


vertical Sum of 10's in colum 1 =20

thank
 
Enter the *specific value* in F1, and
Enter this formula in E1 and copy down:

=(A1=$F$1)*SUM(A1:D1)

Enter this at the bottom of your list:

=SUMIF(A1:A10,F1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

thanks for the help. One more question.

if instead of having a colum, lets say I have 4 columns and every time
a cell in column 1 equals a specific value (such as 10), I need to add
a summation at th bottom of the colum PLUS a summation to the right of
the 4 colums adding up all cells in that row. Let me clarify



10-----20------13-------67--------sum here = 110
12-----7--------44-------92
10-----40------30-------80--------sum here = 160
33-----54------1---------90


vertical Sum of 10's in colum 1 =20

thanks
 
Back
Top