| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Sum a column subject to variables in two columns
Hi,
I already use the SUMIF function to calculate the total mileage for a vehicle stored in columns A1:A50 if another column C1:C50 contains an 'x'. However I now want to calculate the mileage if C1:C50 contains an 'x' and column D1:D50 contains 'y'. I've looked at at various queries on this site re SUMIF with 2 variable but none seem to give an answer on how to nest these two conditione into the 'CRITERIA' part of the function. Please can anyone help? -- Steve D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Headers, one subject column and various columns with data | Charts and Charting in Excel | |||
| SUMIF with two or more variables | Excel Worksheet Functions | |||
| SUMIF formula for two variables in two columns | Excel Worksheet Functions | |||
| Variables in the subject line of an e-mail hyperlink | Excel Discussion (Misc queries) | |||
| SUMIF variables | Excel Discussion (Misc queries) | |||
Threaded Mode
