Finding the sum of different Categories with exeptions

[Lars Poulsen]

I'm working on a project where I need to find the sum of different categories. And there is some exeptions.
It is all typed into the same sheet.
Sorting and finding subtotal is not enough. I tried with pivot, but I could not make it work.

First the exeption. If a row in collum G contains anything (numbers or characters), the data from that row will not be added to the sum.

Collum C contains how many of a thing and collum E contains the value of 1 of that thing. I need the product from each row that is not in the exeption for later.

Collum B contains a category. It can be A, C, G, P, S, U, V or W. Sometimes it is blank, these are for getting a better overview .

Ex. I need to be able to see the sum of the product from all labeled with category V without including rows that have a note in collum G.

[Glenn Kennedy]

Hi. Is this what you meant? If not, please attach a spreadsheet showing wexactly what you do mean.

[Lars Poulsen]

wow you make it look so easy.
I have tried to research it for two days. Not knowing where to start.

Yes that solves my problem. I can work on it from here.

Thanks alot!

[Glenn Kennedy]

Like the man said - it's only easy if you know the answer!! Thanks for the Rep.