i want to calculate how many alarms went off in the past 24 hours
therefore i am using the sum product formula

=SUMPRODUCT(--('Data 14'!$C$8:$C$6533="InAlm"),--('Data
14'!$D$8:$D$6533=B1),--('Data 14'!$A$8:$A$6533(NOW()-1)))

The formula gives me back how many alarms came back based on three different
criteria.

the formula without the last part works just fine but then when i put in the
('Data 14'!$A$8:$A$6533(NOW()-1) it gives me all 0's.