| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumproduct Wildcard
=SUMPRODUCT(--(C6:C20=38473)*(C6:C20<=38503),--(D6:D20="food"),F6:F20)
Expert, Above is the formula i am using, however it will only return a value when only 'food' is contained in the cell. With this formula I have built a simple check-book for my own personal finance. what can i do to this formula to look for 'food' in cells such as ' Giant Food Store' of 'Food Lion'? Thank you, RB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Wildcard * | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
