Adding Figures based on a different columns info

[wowster0]

Dear Experts

I have a workbook where row a = a number and row b = text ie gift, win,
donation etc.

What I am trying to achieve is to add all the gifts, all the wins and all
the donations as seperate numbers, I could do this individually but as there
are 500 plus rows it would seem sensible to try to have this formula driven

Thanks in advance for any guidance

Rgds

Steve

 

[Bernard Liengme]

=SUMIF(B1:B500,"Gift",A1:A500)
or if the text Gift is entered into cell C1, =SUMIF(B1:B500,C1,A1:A500)
best wishes

 

[Debra Dalgleish]

Another option is to create a pivot table to summarize the data. There
are examples and links here:

http://www.contextures.com/xlPivot01.html

 

[wowster0]

Another option is to create a pivot table to summarize the data. There are
examples and links here:

http://www.contextures.com/xlPivot01.html

Brilliant thanks for your responses question well and truly sorted

Rgds

Steve

 

[Alex]

You don't need to specify rows with this formula. This is what I would
do:

=SUMIF(B:B,"Gift",A:A)

Good luck!

Alex.