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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

look up question 1
Help with a formula 7
Seeking a 'special' calendar template 1
Max/min functions similar to SUMIF 3
formula question 6
If then 2
What formula do I use to show the last cell with text in a colum 3
Strange formula 'non-calculation' 1

Back
Top