I was going to use sumproduct but i cant get it to work so i am thinking it
is the onrg formula

I have two columns (well more really but only 2 in each calc).

Column A will be blank or have "C" in it
Column B will have a monitary value
There are a lot of rows

I want to say

If Col A has a C then add the value in column B

So there will be multiple rows with C in and i want a total value of column
B that have the corresponding C in col A