| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF - pointing to another cell for criteria
Please could someone tell me if it is possible to have the criteria point to
another cell, so you can the criteria wihtout having to rewrite the formula. I've tried: =SUMIF(A1:A20,"=D5",B1:B20) but this brings a value of zero. Thank you. Monica |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make criteria in sumif refer to another cell | Excel Worksheet Functions | |||
| Sumif with 2 cell criteria | Charts and Charting in Excel | |||
| How do you reference another cell in the criteria of a SUMIF funct | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
Threaded Mode
