| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need help with a simple xls equation !!
there is prob a very obvious answer but I need to use the "and" function with
the "sumif" function. eg: 3 columns (a= account number b=product & c=value) so: sumif ( range=columns a:c ,criteria=(a="X" & b ="Y"), sum_range=c) I need to use a single cell to calculate the equation? Pls Hlp! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is mathematical equation for NORMDIST (x,mean,standard_dev,TR | Excel Worksheet Functions | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| convert equation to formula | Excel Discussion (Misc queries) | |||
| Rounding in Trendline Equation | Charts and Charting in Excel | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Threaded Mode
