Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
=SUMPRODUCT(([data.xls]PM!$AW$2:$AW$65000>=L3)*([data.xls]PM!$AW$2:$AW$65000<L4)*([data.xls]PM!$B$2:$B$65000="Assigned" + [data.xls]PM!$B$2:$B$65000="Assigned To Vendor"))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel - Lookup tarif based on weight and Zone||5||36|
|Why Won't My Excel Workbook Refresh The Data||2||47|
|where can i download QDE (Quick Date Entry) add-in for Excel?||4||23|
|how to change this formula so that INDEX starts from C2 not C1||1||18|
Join the community of 500,000 technology professionals and ask your questions.