SumIf AND
Thx Fred & Jarek
This is the formula I use to give me a "Cell Count"
=SUMPRODUCT(--(Data!$O2:$O2000),--(Data!$P2:$P200="On Time"))
It returns the correct "On Time" count.
Jarek, your example returns a " #VALUE " Cell response.
=SUMPRODUCT((Data!$P$1:$P$1000="On
time")*(Data!$O$1:$O$10000)*Data!$O$1:$O$1000)
All of the following formula's still equate to 14 (Cell Count), not the
overall value (Cell Sum) itself.
=SUMPRODUCT(--(Data!$P2:$P200="On Time")*(Data!$O2:$O2000))
=SUMPRODUCT((Data!$P2:$P200="On Time")*(Data!$O2:$O2000))
Where-as this equates to 0.
=SUMPRODUCT(Data!$P2:$P200="On Time")*(Data!$O2:$O2000)
In one of my cells I calc an overall total.
=SUMIF(Data!O:O,"0")
Works a treat to get the overall, but it is from this overall, I need to
break it down into 3 categories, On Time, Early & Late.
The opposite is also needed, I also need to identify the above 3 with
negative 0 amounts for a seperate rebating purpose.
Thx again
Mark.
|