Hi!
I want to be able to total up the values in column A but only including the cells in that column which have a certain value in the adjacent cell (in column B).
i.e. something like
=SUM(A1:A100) WHERE B1:B100="SomeValue"
ANy ideas?
Cheers in advance!
Bookmarks