Sumifs only on filtered results

[annaisakiwi]

Hi all

I have a large amount of data, that can be filtered to show different columns.

What I'd like to do, is just have the Weekly Hours columns added up, dependant on the results that are showing as per the filters.

I have this currently in C75, however this gives the total for all columns, even those hidden.

=SUMIFS(D75:EC75,$D$73:$EC$73,$E$73)


Would really appreciate any help in getting the right formula for this.

I'll also be looking to do the averages of the same data.


Thanks

 

[footoo]

https://www.google.com.hk/search?q=...69i57j69i60.1949j0j8&sourceid=chrome&ie=UTF-8

 

[annaisakiwi]

Thanks - yes I have used google, hence posting in here for help.

I understand I can use subtotal functionality, but as well as only doing the visible columns, I also only want to sum the columns that have "Weekly Hours" in another row.

 

[Aladin Akyurek]

Try to post an Excel readable, scaled-down sample along with the expected results: https://www.mrexcel.com/forum/about-board/508133-attachments.html