Hi All
First post here, hope someone can help.
I'm currently using SUMIFS formulas to analyse vat and other things from a list of costs.
=SUMIFS(Net,BCCodes,$L14,VatCode,"S")
All it does is adds up the Net value of all items matching L14 with a vat code "S".
I have similar formulas that add up various combinations of data appearing in column L and returning values from different columns. All is working great, but....
I would like be able to use a filter and get these results to update accordingly.
I have seen from other posts that it can be done using SUMPRODUCT and SUBTOTAL but I can' get my head round it.
Thanks in advance, if someone can help.
Rob
Bookmarks