Formula to determine number of units at each location and status of units

Please help with a formula to determine number of units on rent and in yard at each of the 5 locations:

Legend - OH, NC, MD, MI & CA = location
R = on rent
Y = in yard

Column:
I J K L M N O P Q R
Row:
26 OH NC MD MI CA
27 R Y R Y R Y R Y R Y
28 Units 0 0
29 Units 0 0

formula in cell I28: =SUM(($D$3:$D$44=$I$26)*($E$3:$E$44=$I$27))

formula in cell J28: =SUM(($D$3:$D$44=$I$26)*($E$3:$E$44=$J$27))
Columns:
D E
Rows:
3 CA Y
4 OH Y
5 CA Y
6 OH R
7 CA Y
8 MI Y
9 OH Y
10 MI R
11 MI R
12 MI R
13 OH R
14 OH Y
15 MI R
16 OH Y
17 OH Y
OH Y
NC R
OH R
NC R
NC R
MI R
MD R
OH R
OH Y
OH R
MI R
OH Y
CA Y
OH R
NC R
MI R
MI R
MD R
44 MI R

Please help with a formula to determine number of units on rent and in yard at each of the 5 locations:

Legend - OH, NC, MD, MI & CA = location
R = on rent
Y = in yard

Column:
I J K L M N O P Q R
Row:
26 OH NC MD MI CA
27 R Y R Y R Y R Y R Y
28 Units 0 0
29 Units 0 0

formula in cell I28: =SUM(($D$3:$D$44=$I$26)*($E$3:$E$44=$I$27))

formula in cell J28: =SUM(($D$3:$D$44=$I$26)*($E$3:$E$44=$J$27))
Columns:
D E
Rows:
3 CA Y
4 OH Y
5 CA Y
6 OH R
7 CA Y
8 MI Y
9 OH Y
10 MI R
11 MI R
12 MI R
13 OH R
14 OH Y
15 MI R
16 OH Y
17 OH Y
OH Y
NC R
OH R
NC R
NC R
MI R
MD R
OH R
OH Y
OH R
MI R
OH Y
CA Y
OH R
NC R
MI R
MI R
MD R
44 MI R

Attached is the spreadsheet.

Thanks you,

Equipment Location and Status.xlsx

Write this formula on F12 :

Please Login or Register  to view this content.

On G12 :

Please Login or Register  to view this content.

On F13 :

Please Login or Register  to view this content.

On G13 :

Please Login or Register  to view this content.

Now copy them to right. Hope this will help.

Or you can write single formula for each row. Then
On F12 :

Please Login or Register  to view this content.

On F13 :

Please Login or Register  to view this content.

Thank you very much JeteMc.

Thank you very much sanram.

You are welcomed.