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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
-----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)
Click to expand...

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

eg

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