Summary totals - Data Validation

[Mook-08]

Hi All

See attached worksheet.

I am creating a budget that has a few cost buckets (Column L in the example) using Data Validation.

I would like to summarise these totals referencing the cost buckets in the table on rows 153-156,

but I can't figure out how to total just those line items without celling selecting.

Am hoping there is a quick and easy way so when I add to the list, it picks up the validation and allocates it accordingly.

Thank you for any help help in advance.

[AliGW]

Look at the Insert Subtotals section on this page: https://support.microsoft.com/en-us/...e-b0a3d4a52b3a

[kvsrinivasamurthy]

ARRAY formula in C153 then copied across.

=SUM(IFERROR(($L$4:$L$136=$B153)*(INDEX($N$4:$P$136,,MATCH(C$152,$N$3:$P$3,0))),0))

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.

[Mook-08]

Thank you both for this solution. This worked for me

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.