Sums based on criteria

  • Thread starter Thread starter Randal
  • Start date Start date
R

Randal

Is it possible to create sums in a group footer for only the data that meets
a certain criteria?
 
Randal said:
Is it possible to create sums in a group footer for only the data that meets
a certain criteria?
Click to expand...

Yes.

There are several ways to conditionally count or sum values.

=Count(IIf([field1] = "ABC", 1, Null))
=Sum((IIf([field1] = "ABC", [field2], 0))
 
Thanks Marshall.

Marshall Barton said:
Randal said:
Is it possible to create sums in a group footer for only the data that meets
a certain criteria?
Click to expand...

Yes.

There are several ways to conditionally count or sum values.

=Count(IIf([field1] = "ABC", 1, Null))
=Sum((IIf([field1] = "ABC", [field2], 0))
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

append query results in footer 1
Fields that don't satisfy criteria 1
Total not correct in Footer 1
Access Dcount (multiple criteria) 3
Really need some help with a multi conditional SumProduct 1
Creating conditional totals in report footers 7
Another Running Sum 3
Sum unique entries in report footer 2

Back
Top