If condition is true return sumproduct of two arrays
try
=SUMPRODUCT(--(F1:F100="FL"),G1:G100,H1:H100) "Felipe" wrote: I need to resolve the following: Column F contains different states, one in each row: FL, CA, NY... Columns G and H contain values I need to display in a destination cell the sumproduct of all G and H where F=Florida, in other words, if only F3 and F4 equals Florida, I need G3*H3+G4*H4. Appreciate any help, Felipe |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com