DSUM formula

[PistolPete7]

Need to DSUM Cell K33 and P44, to reflect the change for the filtered/unfiltered table, with an IF function

[José Augusto]

Hi
Use in column
[Job Role] [Yearly Salary]
Business Analyst >=115000 (same line)
Administrative Officer <=65000 (in other line)

Do Advanced filter
Is that you want?

[PistolPete7]

Hi
Use in column
[Job Role] [Yearly Salary]
Business Analyst >=115000 (same line)
Administrative Officer <=65000 (in other line)

Do Advanced filter
Is that you want?

Yeah that's prefect thanks

[José Augusto]

Hi
You can then use in F21 and F23 the follwing formulas

=SUBTOTAL(9,$F$5:$F$17)

=SUBTOTAL(101,$F$5:$F$17)

Don't forget to mark this thread as SOLVED
Regards

[José Augusto]

Hi
You can then use in F21 and F23 the following formulas

=SUBTOTAL(9,$F$5:$F$17)

=SUBTOTAL(101,$F$5:$F$17)

Don't forget to mark this thread as SOLVED
Regards

[PistolPete7]

Hi
You can then use in F21 and F23 the following formulas

=SUBTOTAL(9,$F$5:$F$17)

=SUBTOTAL(101,$F$5:$F$17)

Don't forget to mark this thread as SOLVED
Regards

Do you know how to DSUM Cell F21 and H21, to reflect the change for the filtered/unfiltered tabl, with an IF function to catch 'Zero listing' and return "No Records Found"

[José Augusto]

Try to use

=IFERROR(1/(1/(DSUM(A4:I17,F4,A31:I33))),"No records found")

[PistolPete7]

Try to use

=IFERROR(1/(1/(DSUM(A4:I17,F4,A31:I33))),"No records found")

Worked, but didn't change when the value filter was applied

[PistolPete7]

Worked, but didn't change when the value filter was applied

Meant, It worked but the value didn't change when the advanced filter was applied

[José Augusto]

Hi
DSUM always changes whenever the advanced filter changes, even if you do not apply the filter to the table.
To sincronize both (value and table) use the same strategy but with SUBTOTAL
=IFERROR(1/(1/(SUBTOTAL(9,$F$5:$F$17))),"No records found")

[PistolPete7]

Hi
DSUM always changes whenever the advanced filter changes, even if you do not apply the filter to the table.
To sincronize both (value and table) use the same strategy but with SUBTOTAL
=IFERROR(1/(1/(SUBTOTAL(9,$F$5:$F$17))),"No records found")

If I was going to use the same formula for cells F23 and H23, except change DSUM to DAVERAGE, how could I incorperate: DAVERAGE, DCOUNT and IF function into the formula
=IFERROR(1/(1/(DAVERAGE(A4:I17,F4,A31:I33))),"No records found")

[PistolPete7]

Hi
DSUM always changes whenever the advanced filter changes, even if you do not apply the filter to the table.
To sincronize both (value and table) use the same strategy but with SUBTOTAL
=IFERROR(1/(1/(SUBTOTAL(9,$F$5:$F$17))),"No records found")

Thanks also, you have been a big help