Multiple Logic in One Formula

Joined
Jan 8, 2015
Messages
2
Reaction score
0
I Have a table like the attached images. I want to extract the latest "Project Starting date) subject to "Project Completed" and "Project Site.

"I want to know the latest project started date where the the project already completed in Dhaka.

I have tried with the following formula..

=MAX(IF(AND(Times!D3500=G1,Times!A3:A500=G2),Times!B3:B500))

But answer returning "0"

whereas the answer should be 12th May ..
Please help me friends...
 

Attachments

  • Untitled.png
    Untitled.png
    32.3 KB · Views: 174

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

Top