Related:
- Excel Formula Help
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Position formula in excel - Excel Forum
1 reply
Hi airolgmd,
So your sheets look a bit like this:
In this case there are 4 rows containing both a 1 and a h. Use the following formula to get this result:
=SUM((A1:A11=1)*(B1:B11="h"))
This is an array formula, so confirm by hitting Ctrl+Shift+Enter.
As clear as a rainy day, right?
Best regards,
Trowa
So your sheets look a bit like this:
1 h 1 h 1 a a h a 1 h 1 h h 1 a 1 a
In this case there are 4 rows containing both a 1 and a h. Use the following formula to get this result:
=SUM((A1:A11=1)*(B1:B11="h"))
This is an array formula, so confirm by hitting Ctrl+Shift+Enter.
As clear as a rainy day, right?
Best regards,
Trowa