Related:
- Excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
Hi Manu,
I used sheet 1 cell B1 to input the following formula:
=SUM((Sheet2!$A$1:$A$16=Sheet1!A1)*(Sheet2!$B$1:$B$16="No"))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
You can now either choose to re-enter your number in cell A1 to see the result in B1.
Or you can drag the formula down to see the result of multiple entries.
Best regards,
Trowa
I used sheet 1 cell B1 to input the following formula:
=SUM((Sheet2!$A$1:$A$16=Sheet1!A1)*(Sheet2!$B$1:$B$16="No"))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
You can now either choose to re-enter your number in cell A1 to see the result in B1.
Or you can drag the formula down to see the result of multiple entries.
Best regards,
Trowa
