If Statement??

[CThai]

Hello – I have an excel 2007 and I would like to have a total records counts IF column A equal to a text value of “T” and a text value of “S” and column B equal to a text value of “TMS” show me total records. I try doing Sum and look up…but that only give me the 1 number… I’m not sure how to get more then 3 values to give me the total numbers of records… please help.

thank you!

 

[Trevor G]

Try looking at SumIFs as you are using 2007 this will allow you to add multiple criteria.

 

[VoG]

Try

=SUMPRODUCT(--(B1:B100="TMS"),--ISNUMBER(MATCH(A1:A100,{"T","S"},0)))

 

[CThai]

THANK YOU! this work !

 

[CThai]

hi VoG

sorry - quick question - will the formulas also work if column A have a number as well? can i use the same logic?




=SUMPRODUCT(--(B1:B100="TMS"),--ISNUMBER(MATCH(A1:A100,{"1"},0)))

 

[VoG]

If you are looking to count just 1s then

=SUMPRODUCT(--(B1:B100="TMS"),--(A1:A100=1))

 

[CThai]

THANK YOU SO MUCH!!! it works