D
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
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
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