Try this syntax
=MAX(IF((Community=Z1)*(Date>=Z2)*(Date<=Z3),Usage))
confirmed with CTRL+SHIFT+ENTER
where Z1, Z2 and Z3 contain a specific community name, start date and end date respectively
Try this syntax
=MAX(IF((Community=Z1)*(Date>=Z2)*(Date<=Z3),Usage))
confirmed with CTRL+SHIFT+ENTER
where Z1, Z2 and Z3 contain a specific community name, start date and end date respectively
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks