DCount Function

[tjs310]

I currently have a function in place where I search a data source for items containing a certain date with 2 sets of parameters. For example, find 8/23/2012 in the "completed" column "=DCOUNT(Cases!1:1048576,"completed",C10:C11)" where C10 contains "completed" and C11 contains "8/23/2012". How change I change this formula to return a value from a different column from the same row and sum them. For example, find all 8/23/2012 items in the "completed" column, then find the value in the "x" column of the same row and total them.


Thanks,
</SPAN>

 

[barry houdini]

Hello tjs310, welcome to MrExcel

Try using DSUM, i.e.

=DSUM(Cases!1:1048576,"x",C10:C11)

 

[tjs310]

That sums up the cell I am searching for. I want the function to sum the amount of a cell in a different column in the sale row. For example, search for all 8/23/2012 values in column x. Once found, sum up all the values in column y of the same rows.

 

[barry houdini]

....find all 8/23/2012 items in the "completed" column, then find the value in the "x" column of the same row and total them...

The formula should do what you want if you leave C10 as "completed".

If you use my suggestion, i.e.

=DSUM(Cases!1:1048576,"x",C10:C11)

then that will sum the column named ("x" in this case) based on the C11 criteria found in the column named in C10....so C10 shouldn't match the column named in the formula otherwise it does as you suggest.