Microsoft Windows vista home premium 64-...

Hi

I have in column B three different types of data marked as S M and PD, and some other taht i don't need to calculate. in the next column (C) I have the numbers (35, 23 etc) Is it possible to create the formula that adds up the total form C column if anything in a B column equals S, then total from C column if anything in B column = M and last total from C if B column = PD?

The =SUMIF function is what your looking for: B C s 35 m 23 pd 12 s 35 m 23 pd 12In Cell C7 but the formula: =SUMIF(B1:B6,"s",C1:C6)

and you will get the sum of all the S letters,

In Cell C8 put the formula: =SUMIF(B1:B6,"m",C1:C6)

and you will get the sum of all the M letters.You should be able to figure out the rest.

MIKE

Thank you Mike for your help. That's brilliant and helped me a lot! and it is easy :)

Could you tell me what formula I should use if i have two conditions, i.e. if anything in column A = "in" and anything in column B= "S" add up numbers in column C? and also would it be possible to have those results in a sheet number 2 instead of same sheet with data? Thanks for helping me out! really apreciate!

Kat

You will need an arrayformula.When you enter the formula you

mustuse the

CTRL - SHIFT - ENTER combination, else it won't work.A B C in s 35 out m 23 in pd 12 out s 35 in m 23 out pd 12In Cell C7 put the formula:

=SUM( ( A2:A7 = "in" ) * ( B2:B7 ="s") * C2:C7 )

and you will get the sum of all the S letters in column B,

that also have the word IN in column A

You should be able to figure out the rest.Again, this is an

arrayformula, use CTRL - SHIFT - ENTERAlso, for new questions, start a new thread.

Thanks.MIKE

Just remembered you wanted this on sheet two. On Sheet 2 in Cell A1 enter this revised formula:

=SUM( ( Sheet1!A2:A7 = "in" ) * ( Sheet1!B2:B7 ="s") * Sheet1!C2:C7 )

MIKE

Great thank you so much for your help

Ask Your Question

Weekly Poll

Do older people you know use the Internet?

Discuss in The Lounge

Poll History