View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default funtion SUMAR.SI

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:

how I can make a multiple condition in function SUMAR.SI?