Hi i am looking for a sum formula!
I was hoping one of you guys as EXCEL FORUM could help me!
Basically i have a number of text values in column A just for example GCSE, AQA, NVQ, PIE Just for examples and then in Column B i Have say grades like A, B, C, OR D Depending on the grade given.
I was wondering if there was a sum formula that looks for say the word gcse in column A and then sums only the cellls in column B with say A or B Values.
I hope this makes some sense let me know if you need some more info.
JAmidd
Bookmarks