M Marcelo Dec 17, 2007 #2 Hi, I think you are talking about SUMIF. you can use Sumproduct (maybe SUMARPRODUCTO in spanish), =sumproduct(--(a2:a1000="1st conditional")*(b2:b1000="2nd conditional");(c2:c1000)) it'll return the sum of the data on the C column if the data on columns A and B match with the conditionals. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "xavi" escreveu:
Hi, I think you are talking about SUMIF. you can use Sumproduct (maybe SUMARPRODUCTO in spanish), =sumproduct(--(a2:a1000="1st conditional")*(b2:b1000="2nd conditional");(c2:c1000)) it'll return the sum of the data on the C column if the data on columns A and B match with the conditionals. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "xavi" escreveu:
