C
computers hate me
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.
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.