View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cindi Cindi is offline
external usenet poster
 
Posts: 22
Default If statement to total grades

Thanks! It worked great!
--
JustLearning


"N Harkawat" wrote:

On total place this formula adjusting for the range ofcourse
=SUMIF(A1:A10,"""",B1:B10)

"Cindi" wrote:

I'm new at this and I need help totaling grades on a spreadsheet. I want to
say if column A contains any letter grade then add column B to the total.
How can I do this? Thanks.
--
JustLearning