Max / IF questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
Back
Top