Sum up all of the C's or D's in a column that contain a specific word in another column

[smockpuv]

I have a table and in column A I have a list of words, in column D I have a letter either a C or D for certain criteria. Column A has a bank of about 7 words that are repeated. I want to sum up all of the letter Ds that appear in correlation with each word.

www.google.com	C
www.yahoo.com	D
www.ksl.com	D
www.google.com	C
www.google.com	C

This is over simplified, but basically in another sheet I want to be able to say www.google.com has XX amount of D, or C throught the spreadsheet.

Thanks

[Break_Point]

This will return the number of times C & D appears in column D where google.om appears in column A.

To count Cs for google

Please Login or Register  to view this content.

To count Ds for google

Please Login or Register  to view this content.

[smockpuv]

Very nice. I was trying to use the SUMIF function, didn't know about the countif(s) function. Thanks again!