DSUM I think

[donflak]

I have a need to sum data from a table on a different sheet in a
workbook but I need it to only return data that matches multiple
criteria.

The table has multiple columns but the 3 important columns are A, E, &
H.

I have column headers A=FIN, E=LDC, and H=OT

On the report page I am assembling I have a column (A) which includes
Finance Numbers.

I need a formula that will search the SATURDAY tab of the workbook
which contains data through line 35000 and sum the figures in the OT
column only if certain criteria in the FIN column and the LDC column
match.

I have the following LDC criteria already established in S1:T3

LDC LDC

=2000 <=2999
=9200 <=9200

The formula I already have is:

=DSUM(SATURDAY!$A$1:$J$35000,"OT",$S$1:$T$3)

The problem is that this formula does not filter the data for finance
number relevance, it only filters based on the LDC criteria I
established in S1:T3.

How do I add the 2nd criteria to match the value I have in my report
column A with the values in the SATURDAY tab Column A "FIN".

I need my results filtered on both criteria.

Thanks in advance for any assistance you can provide.

Don

 

[Tom Hutchins]

Add another column to your criteria section, titled FIN. In this column pull
in the values you need to match from the report sheet. You will have to
repeat the LDC criteria for each FIN value in the criteria section. For
example, using your LDC criteria, if the FIN values to match are AAA, BBB,
and XXX, your criteria section might look like this:

FIN LDC LDC
AAA >=2000 <=2999
AAA >=9200 <=9200
BBB >=2000 <=2999
BBB >=9200 <=9200
XXX >=2000 <=2999
XXX >=9200 <=9200

and your DSUM formula might be
=DSUM(SATURDAY!$A$1:$J$35000,"OT",$S$1:$U$7)

I don't understand the second line of your LDC criteria. >=9200 AND <=9200
will only return values exactly equal to 9200.

Hope this helps,

Hutch