Sum values in a range where adjacent cell values meet a criteria

[plaidshirt]

I tried to use formula below to sum cell values in a given range by a given criteria.

=SUM(IF(Asheet!I:I="Y";Asheet!F:F;0))

It should values from F, where values in I are Y.

 

[Aladin Akyurek]

That would require applying control+shift+enter in Excel, not just enter.

You can also try:

=SUMIFS(Asheet!F:F,Asheet!I:I,"Y")

which requires just enter and it's faster.

 

[gaz_chops]

Welcome to MrExcel,

Try

=SUMIFS(F:F,I:I,"Y")