| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(and(function help)
I have a worksheet similer to the following with data range names:
User Item Debit Adam Lunch $1.70 Alex Milk $0.30 Alex Lunch $1.55 Adam Snack $0.50 This is the formula I can't get to compute: =if(and(user="Adam",item="Lunch"),sum(Debit),"" Any clue as to why it will not work? |
Threaded Mode
