How do I add a list of numbers in a colum that = a repeating word.

[Guest]

I am trying to add a list of numbers that the critera is a repeating word
like monday in another colum. I know how to use lookup formula but this one
has challenged me.
Example of problem: Column1 Mon, Tue, Wed Thurs Fri Sat Sun Mon Tue Wed.....
Column2 2 3 10 4 5 7
3 2 3 4 .....

Give the total sum on colum 2 where Column 1 = Monday.

Please help.

 

[Ken Wright]

=SUMIF(Range2Query,"Mon",Range2Sum)

 

[BEK]

-----Original Message-----
I am trying to add a list of numbers that the critera is a repeating word
like monday in another colum. I know how to use lookup formula but this one
has challenged me.
Example of problem: Column1 Mon, Tue, Wed Thurs Fri Sat Sun Mon Tue Wed.....
Column2 2 3 10 4 5 7
3 2 3 4 .....

Give the total sum on colum 2 where Column 1 = Monday.

Please help.
.
Try to use function sumif(Range,Criteria,Sum Range)

Where the Range Contains the Criteria value and Sum_Range
is the column to be added.

eg

=sumif(A1:A23,"Monday",B1:B23)