In EXCEL 2007, Been using COUNTIFS for awhile, now all the sudden I can't get it to work. Please see the below table and let me know if I am going crazy. Because I can't figure out what the @#%$ is giving me these MET #'s.
Shouldn't
A2=2, A3=3, A4=3
A2=COUNTIFS(B2,">=10",C2,">=20",D2,">=30")
A3=COUNTIFS(B3,">=10",C3,">=20",D3,">=30")
A4=COUNTIFS(B4,">=10",C4,">=20",D4,">=30")
<TBODY>
</TBODY>
Shouldn't
A2=2, A3=3, A4=3
A2=COUNTIFS(B2,">=10",C2,">=20",D2,">=30")
A3=COUNTIFS(B3,">=10",C3,">=20",D3,">=30")
A4=COUNTIFS(B4,">=10",C4,">=20",D4,">=30")
A | B | C | D | |
1 | MET | >=10 | >=20 | >=30 |
2 | 0 | 20 | 20 | 19 |
3 | 1 | 15 | 21 | 30 |
4 | 1 | 10 | 25 | 39 |
<TBODY>
</TBODY>