Sumif not working

[Shabbo]

Dear Sir,

I applied sumif but its not giving result, showing zero only.

 

[herofox]

hi you can to use this

=SUMIF(Sheet1!$B:$B,$A2,Sheet1!$A:$A)

 

[pecoflyer]

As you have not provided the formula you tried, we cannot see what went wrong.
Another solution is a Pivot Table based on an Excel Table which will extend the data source automatically without having to reserve the entire columns (IMO using entire column/range references is bad practice, BTA that is MY opinion)

 

[csarxex]

Estimado señor,

Apliqué sumif pero no da resultado, mostrando cero solamente.
[/CITA]

si me funciona cuando existe el control