Array Formulas

[John Telly]

I have a workbook with several worksheets. They are to
pull data from a single worksheet (in the same workbook)
via the formula: {=sum(if($B$4=Hour Data!$F$3:$F$53,Hour
Data!M$3:M$53)))}.
This formulas seems to be somewhat'moody" in that some
worksheets pull the data OK and others don't. I even try
to invoke the array through F2 Ctrl Shift Enter to no
avail.
fyi, I have the spreadsheet on manual calculation. But
the problem is still there even after I recalculate.
Many Thank,
John

 

[JMay]

The Sumproduct() formula seems more popular for such. Try:
=SUMPRODUCT(('Hour Data'!$F$3:$F$53='Hour Data'!$B$4)*('Hour
Data'!$M$3:$M$53))
HTH