code for Sum on the basis of criteria

[Veeru106]

Hi,


I am looking for one code , which gives me sum of filtered values (mentioned in Creteria tab- Vrtt,Grtt and Utt for Fin deptt.) from FY-2017 tab and paste total in Summary tab in B1 cell.
Thanks

 

[Hareesh_KLD]

Hi,

You can use DSUM function for this

 

[Hareesh_KLD]

Vba code for Dsum

 

[Veeru106]

Thank you...please confirm how you have defined Criteria range from H3 to L6 and data table starting from A1 to E16...

 

[Hareesh_KLD]

For Database and criteria arguments in Dsum function you have to take all range including headers

For field argument you can take Field Name within double quotes or index number

 

[Veeru106]

Dsum Formula is good but when my data changes next month then i need to change range of the table as well, which i want to avoid. that's why i am looking for code.i will try to use your code and let you know the results. thank you..

 

[Hareesh_KLD]

Better if u post u r data and requirement in a workbook