ExcelBanter - I can see th formula result in the dialog box but not in the cell

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

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

- - I can see th formula result in the dialog box but not in the cell (https://www.excelbanter.com/excel-worksheet-functions/52637-i-can-see-th-formula-result-dialog-box-but-not-cell.html)

Worried

I can see th formula result in the dialog box but not in the cell

I am working with exel and I am using the IF and SUM Funcions, I can see the
result of the next formula in the formula result dialog box but the cell
shows 0 can somebody help me?
=SUM(IF($A$3:$A$129=F4;$B$3:$B$129;0))

JE McGimpsey

I can see th formula result in the dialog box but not in the cell

You need to array-enter this formula (using CTRL-SHIFT-ENTER or
CMD-RETURN).

In article ,
"Worried" wrote:

I am working with exel and I am using the IF and SUM Funcions, I can see the
result of the next formula in the formula result dialog box but the cell
shows 0 can somebody help me?
=SUM(IF($A$3:$A$129=F4;$B$3:$B$129;0))

All times are GMT +1. The time now is 02:20 PM.