I am attempting to multiple two arrays, but only if array 2 meets a greater than or equal to criteria. That criteria is >=243
| Array 1 | Array 2 |
| 5 | 200 |
| 5 | 240 |
| 5 | 280 |
| 5 | 320 |
I have attempted to use the following formula: =SUMPRODUCT(--(Program!F4:F8>=(VLOOKUP(Results!$C$10,Start!$B$3:$H$8,4,0)*Results!E22)),Program!E4:E8)
Which is simplified to: =SUMPRODUCT(--(Program!F4:F8>=240)),Program!E4:E8)
This returns the number 10, which I assume is because it returns the true values as 1, and then are multiplied by 5 and summed.
How may I fix this to return 3000?
Aucun commentaire:
Enregistrer un commentaire