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
"(E-Mail Removed)" wrote:
> 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
>
|
Similar Threads
