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
|