lundi 1 juin 2020

SUMPRODUCT function with IF logic

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