If condition is true return sumproduct of two arrays
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 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com