R
rdbjr99
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.
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.