| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
| 2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
| How to get date entered recording first time condition is true? | Excel Discussion (Misc queries) | |||
| Sumproduct - Return a String | Excel Discussion (Misc queries) | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Linear Mode
