Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to total grades
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to total grades
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to total grades
Is 'the total" for the entire worksheet, or just for a given row?
If the former: =SUMPRODUCT(--(ISTEXT(A1:A35)),B1:B35) adjust the ranges as needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cindi" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to total grades
Thanks. This gives me different ideas. I appreciate the help!!
-- JustLearning "Bernard Liengme" wrote: Is 'the total" for the entire worksheet, or just for a given row? If the former: =SUMPRODUCT(--(ISTEXT(A1:A35)),B1:B35) adjust the ranges as needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cindi" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assigning grades | Excel Worksheet Functions | |||
Grades to Marks | Excel Worksheet Functions | |||
Figuring Grades | Excel Worksheet Functions | |||
Grades | Excel Worksheet Functions | |||
grades | Excel Discussion (Misc queries) |