charlesloves2read
Board Regular
- Joined
- Aug 11, 2010
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
Hi folks, I am using a really long formula of countif and I am looking for a way to simplify them.
Basically I am copying and pasting it from row 4 to row 91! Thanks!
=COUNTIF(E$4:Q$4,S4)*D$4
+COUNTIF(E$5:Q$5,S4)*D$5
+COUNTIF(E$6:Q$6,S4)*D$6
+.....
+COUNTIF(E$91:Q$91,S4)*D$91
Basically I am copying and pasting it from row 4 to row 91! Thanks!
=COUNTIF(E$4:Q$4,S4)*D$4
+COUNTIF(E$5:Q$5,S4)*D$5
+COUNTIF(E$6:Q$6,S4)*D$6
+.....
+COUNTIF(E$91:Q$91,S4)*D$91