Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
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 |