check if then else?

[Vass]

Can someone point me in the right direction please.

I have a column where a user enters a number between 1 and 7
all the way down 30 lines
to the right of this they enter an amount
I'd like to create a set of totals of the amounts for each number
i.e. 1 £ 45
2 £ 20
1 £ 15


total 1 = £ 60
total 2 = £ 20
etc

I'm sure this is a simple function but I am struggling with it

thanks in advance

 

[Dave Peterson]

Select your data (all the columns)
sort by the number column using Data|Sort
then use Data|subtotals to get your totals.

You can use the outlining symbols at the left to hide/show the details.

 

[Don Guillett]

have a look in help index for SUMIF

 

[Vass]

have a look in help index for SUMIF

Perfect !

=+SUMIF(Exp_Code,7,$I13:$I43)

thanks

 

[Don Guillett]

glad to help
Excel is not lotus. you do not need the +

=SUMIF(Exp_Code,7,$I13:$I43)