Report Total using where clause (1 Viewer)

[boycie]

Hi,
I am trying to create a total in the footer by summing up fields in the detail area using a certain criteria. For example; The report has 3 fields: Name,Job Title, Days Worked. I want to sum all days worked "where Job Title = Gardener for example.
Can anyone help?
thanks

 

[pbaldy]

Try

=Sum(IIf([Job Title] = "Gardener", [Days Worked], 0))

 

[boycie]

Thanks Paul, that worked great!

 

[pbaldy]

Happy to help!