| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT or SUMIF if any values in a range equal any values in another range
Let's say I have values in range A1:A26.
Next I have some values in range Z1:Z7. I'd like to do some sort of SUMIF or SUMPRODUCT that if any of the values in Z1:Z7 are in the range A1:A26, I'd like to SUM the corresponding values in O1:O26. Is there a simpler way to do this than daisy-chaining a bunch of SUMIFs together? Thanks, Paul -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF result including values not specified in sum-range | Excel Worksheet Functions | |||
| adding values if the same - SUMIF in range of cells? | Excel Worksheet Functions | |||
| sumif for a range of values | Excel Discussion (Misc queries) | |||
| using sumif to sum a range of values | Excel Worksheet Functions | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
Threaded Mode
