Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif on columns with logical answers
I am having trouble with a formula.
I am trying to sum a column with logical answers in. F G H I J 1 Sonosor Signs Teams Dinners Caps 2 Ace 6 4 16 16 3 Birdie 2 1 4 4 4 Par 1 0 4 4 My formulas in columns G thru J are logistical that if F2 reads "Birdie" return the value of 2 in cell G2, if F2 reads "Ace" return the value of 6 in cell G2, etc. I have thirteen values to return for specifice sponsorhips in each column G thru H. When I try to put in G5, H5, I5 & J5 the sum of total column for total signs to order, teams, dinners and caps it is not adding the column for me. I have tried countif, sum and sumif. What am I doing wrong in my total column formula? When I enter "=sumif(g2:g4,"?")" it returns 0, If I enter "=countif(g2:g4,"?")" it returns 3, If I enter "=sum(g2:g4)" it returns 0. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif on columns with logical answers
Show us the formula in G2
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "JGilbert" wrote in message ... I am having trouble with a formula. I am trying to sum a column with logical answers in. F G H I J 1 Sonosor Signs Teams Dinners Caps 2 Ace 6 4 16 16 3 Birdie 2 1 4 4 4 Par 1 0 4 4 My formulas in columns G thru J are logistical that if F2 reads "Birdie" return the value of 2 in cell G2, if F2 reads "Ace" return the value of 6 in cell G2, etc. I have thirteen values to return for specifice sponsorhips in each column G thru H. When I try to put in G5, H5, I5 & J5 the sum of total column for total signs to order, teams, dinners and caps it is not adding the column for me. I have tried countif, sum and sumif. What am I doing wrong in my total column formula? When I enter "=sumif(g2:g4,"?")" it returns 0, If I enter "=countif(g2:g4,"?")" it returns 3, If I enter "=sum(g2:g4)" it returns 0. Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF across Columns | Excel Worksheet Functions | |||
Can I use more complex logical expression for sumif as creteria? | Excel Worksheet Functions | |||
my sumif statement brings back mutiple answers, how do I fix it? | Excel Worksheet Functions | |||
Sumif across columns | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions |