ExcelBanter - sum if

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sum if (https://www.excelbanter.com/excel-worksheet-functions/22578-sum-if.html)

choice

sum if

how can i get this work?

=sumif(a1:a100,3,b1:z100)

thanks in advance

Peo Sjoblom

You cannot use sumif like that, it needs same sized ranges

=SUMPRODUCT((A1:A100=3)*(B1:Z100))

--
Regards,

Peo Sjoblom

"choice" wrote in message
...
how can i get this work?

=sumif(a1:a100,3,b1:z100)

thanks in advance

All times are GMT +1. The time now is 12:30 AM.