Sum If Meets Criteria

[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

 

[Ken Wright]

Examples and variants

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

 

[Bob Phillips]

=SUMIF(A1:A20,">20"

--

HTH

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

 

[Bob Phillips]

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)

=SUMIF(A1:A20,">20"

--

HTH

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

 

[halem2]

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

 

[RagDyer]

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

=(A1=$F$1)*SUM(A11)

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

 

[halem2]

thanks for all your help. It works great