basic excel question

[5ingh]

yo,

never really used excel functions that much before, so i hope you can help me with something simple (i hope). i want to be able to calculate the total for a given 'text value' into a single cell.

image:

so something like: =if(A:A="banana", then calculate total cost for every banana into a single cell (35p).

thanks!

 

[5ingh]

cheers for the reply,

googled excel arrays and after abit of tweaking i'm getting what i need!

=SUM((A2:A9999="banana")*(B2:B9999))
(press f2 on the formula cell, ctrl+shift+enter)
=£0.35

it doesn't seem to like multiple datatypes in a single column though (the headings) - hence the reason why ive started with a2/b2 instead of a:a / b:b