D
Doris Morris
I have a report where I need to sum the number of hotels we have if the owner
type is "F" and the project type is "New Build". Can I use the sum and if
functions at the same time? I tried the following but it did not work.
=Sum([hotels])IIF([owner type] = "F" and [project type] = "New Build"))
type is "F" and the project type is "New Build". Can I use the sum and if
functions at the same time? I tried the following but it did not work.
=Sum([hotels])IIF([owner type] = "F" and [project type] = "New Build"))