Sum If

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

Is it possible to do a SumIf calculation in an Access 2003 report (similar to
what I can do in Excel)? For example, I have various values displayed in a
Color field on my report. I would like to create a formula that will count
only the blue values.
 
Lynn said:
Is it possible to do a SumIf calculation in an Access 2003 report (similar to
what I can do in Excel)? For example, I have various values displayed in a
Color field on my report. I would like to create a formula that will count
only the blue values.
Click to expand...

=Sum(IIf(something = "blue", 1, 0))

or one of any number of various similar expressions.

BUT, that make your expression dependent on a data value.
Instead you should use a Totals type query to calculate the
count for all the different colors.
 
Back
Top