Need help with a formula.

[James2376]

How can I create an Excel formula that, in the 'Arbeidstasjoner' sheet, uses the machine name in cell B3 and the date in cell E2 to check if any lines in the 'SQ1' sheet match both the B3 machine name and E2 date? If matches are found, the formula should return the sum of values in column 7 for all matching lines. For example, if it identifies 2 lines with machine name 'N001' and date '10/17/2023,' where the column 7 values are 3 and 5 respectively, the formula should return '8' as the sum (3 + 5 = 8).

https://docs.google.com/spreadsheets/d/e/2PACX-1vSMImZEOhzGblXBxFCPOUm-T2HJ4UfQMmRrSCuWZ_MsOZKlE3AngZEX69ANUyR9Iw/pubhtml

 

[Fluff]

You can use the sumifs function for that. SUMIFS Function