Selecting and adding

[Nativus_N00b]

Hello,

I have two columns. Column P contains categories and column K prices.

I’d like to create a formula to select all prices of one category (eg. boodschappen) and return a sum.

Thanks

[keme1]

For a single sum, where you select one category, use SUMIF()

To create a listing of all categories wit their respective sums, use a pivot table.

[Nativus_N00b]

=SUMIF($Bank.P$3:P$75;“Boodschappen”;$Bank.K$3:K$75)

Much appreciated!