Microsoft Office Excel

By harpergirls ·
Tags: Software
What is the excel formula to find the invoiced amount for the latest date for a specific contract number and contract line item number (CLIN)? Column A is a list of different contract numbers, Column B is the corresponding CLIN, Column C is the invoiced date and Column D is the invoiced amount. Thanks in advance for the help! I am using MS Office Excel 2013.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Microsoft Office Excel

by ava2 In reply to Microsoft Office Excel

Assuming that:
- your data are in columns A:D, starting in row 2 (row 1 contains the headers) ;
- the desired Contractnumber is in E1 ;
- the desired CLIN is in F1 ;
then you can use this formula, confirmed with Control - Shift - Enter:

Related Discussions

Related Forums