View Single Post
  #2   Report Post  
JMB
 
Posts: n/a
Default

By adding another argument, do you mean to return the last meeting date
(either onsite or off site)?

=MAX(IF('Contact Details'!D54:D68={"Onsite Meeting","Off Site
Meeting"},'Contact Details'!B54:B68))

"G" wrote:

Hi ..
I am using the following formula to calculate the last date i had a meeting
with a customer .. =MAX(IF('Contact Details'!D54:D68="Meeting",'Contact
Details'!B54:B68))

The meetings are now reported as "onsite meeting" and "off site meeting" is
there a simple way to add another argument in to the IF statement ??

Thanks