Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum data if 3 criteria are met
I'm trying to come up with a formula that will let me sum data in one column
if three criteria are met in the other columns. Here is sample data: A2:A65535 = Dates (looking for all items that = 3/15/2008) C2:C65535 = Text (looking for all items that equal = "eChannel") O2:O65535 = Text (looking for all items that equal = "Direct Expense") AG2:AG65535 = Numbers (I want to sum all numbers if all three criteria above are met for a particular row) So, I want to sum column AG for all rows that have 3/15/2008 in column A, "echannel" in column C, and "Direct expense" in column O. I've tried Ctrl-Shift-Enter formulas but I must not have them correct. Also I've tried SUMPRODUCT formulas but here again I must be doing something wrong. Thanks in advance for any help. -- rdbjr99 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looking up data in a table using 2 criteria | Excel Worksheet Functions | |||
SUM data if meets criteria | Charts and Charting in Excel | |||
data entry criteria | Excel Worksheet Functions | |||
arrange data by criteria | New Users to Excel | |||
under certain criteria copy data. | Excel Worksheet Functions |