Related:

- Excel Formula Help
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets

## 1 response

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