| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thank you so much!! This worked great! bj wrote: try something like =sumproduct(--(visit range<0),Cost range) in your totals column. note the Visit range and Cost range must be the same size the --( converts the true false logical statement to a 1,0 numeric value. Hello, [quoted text clipped - 17 lines] I hope this makes sense!! If anybody has any idea or resources that I could follow up with, I'd greatly appreciate it!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
| What statement to use? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Threaded Mode
