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!
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!
