sumifs excluding certain items

your post #6

Hi there - I see that as a away of generating the solution

could you explain why you think a pivot table is not usefull for you.

Originally Posted by Tradesman

Hi there - I see that as a away of generating the solution but my data is live so wil chnage as wil the date periods going forward- I need to be able to chnage the table titles - and then refer to the data giving the result -

Originally Posted by oeldere

your post #6

Hi there - I see that as a away of generating the solution

could you explain why you think a pivot table is not usefull for you.

Pivot tables do not refresh automatically, which is one reason why I rarely use them. Above the OP explains why he doesn't want to use them in this instance.