IIF FUNCTION and multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can these formulas be used to count multiple values? For instance, if I want
to count the number of values >8 in addition to the number of values =1. I'm
using it with a text field so please consider this when replying.
Thanks.

=Count(IIf(hours > 8, 1, Null))

=Sum(IIf(hours > 8, 1, 0))

=Abs(Sum(hours > 8))
 
hi Karina,
Can these formulas be used to count multiple values? For instance, if I want
to count the number of values >8 in addition to the number of values =1. I'm
using it with a text field so please consider this when replying.
=Count(IIf(hours > 8, 1, Null))
=Sum(IIf(hours > 8, 1, 0))
=Abs(Sum(hours > 8))
Click to expand...
Do they throw any error?


mfG
--> stefan <--
 
If I understand correctly, try:
=Abs(Sum(hours > 8 OR hours=1))
If that doesn't meet your needs, please come back with a more complete spec.
 
Back
Top