Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello!
I am trying to create a formula that will sum up certain criteria from one column as it relates to criteria in the same row in another column. For example, I want to sum up all the entries that begin with the letter "H" in column A as it relates to an entry of "2" from column B that is in the same row as the "H" entry from column A. COLUMN A COLUMN B H10 2 G01 2 H09 3 H15 2 H12 2 If there is such a formula, the answer from the example would be 3 Any help would be appreciated! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating an IF Formula | Excel Discussion (Misc queries) | |||
Help Creating A Formula | Excel Worksheet Functions | |||
Creating a new formula | New Users to Excel | |||
Creating a formula | New Users to Excel | |||
HELP creating formula! | Excel Worksheet Functions |