| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Here is my problem
I want to sum the values in a column if they meet two criteria, see below: A B C D Site Vehicle Value 4 Wheeler Bardon Bardon 4 Wheeler 1000 Croft 4 Wheeler 2000 Bardon 4 wheeler 3000 In column D I want it to sum the value column if A equals Bardon and B equals 4 wheeler. I have done this with one column using the following: =SUMIF(T4:T47,"4 wheelers",F4:F47) can I use the AND function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
