Question

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.
1 total post (Page 1 of 1)  
| 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:
=IFERROR(INDEX(D$2:D$100;MATCH(MAX(IF(A$2:A$100=$E$1;IF(B$2:B$100=$F$1;C$2:C$100)));C$2:C$100;0));"")

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums