=SUMIF(F7:F44=A62,IF(G7:G44="won"*3),IF(G7:G44="Drew"*1)f7:f44 is teams that has to match a62g7:g44 is won, drew, lost if won 3 points & if drew 1 point the formula above sầu isnt working as when i đầu vào it it says "The Formula you typed contains an error" but i cant see where
Register To Reply
Forum Guru
When I type in your formula it stops on the "*3"=SUMIF(F7:F44=A62,IF(G7:G44="won"*3),IF(G7:G44="Drew"*1)Start looking there. Also if you clichồng on the Formulas Tab và then on Evaluate, you can step through your formula to find the problem yourself.http://www.dummies.com/software/micr...2010-formulas/ is an example of the screen you should use.
One chạy thử is worth a thousvà opinions.
Cliông xã the * Add Reputation below lớn say thanks.
Register To Reply
FYI: an alternative sầu ....=COUNTIFS(F:F,"=" &A62,G:G,"=won")*3+COUNTIFS(F:F,"=" &A62,G:G,"=draw")If that takes care of your original question, please select Thread Tools from the menu link above sầu & mark this thread as SOLVED. Thanks.
The above works perfect khổng lồ bởi what i want but i need it lớn ignore "Upcoming"whisch is in column g also upcoming only changes ones a game is finished =SUMPRODUCT(($F$7:$F$44=$A62)*(($G$7:$G$44="Won")*3+($G$7:$G$44="Draw"))) - where & how would i get it to ignore $G$7:$G$44="upcoming?"
The above works perfect to lớn vị what i want but i need it lớn ignore "Upcoming"whisch is in column g also upcoming only changes ones a game is finished =SUMPRODUCT(($F$7:$F$44=$A62)*(($G$7:$G$44="Won")*3+($G$7:$G$44="Draw"))) - where và how would i get it lớn ignore $G$7:$G$44="upcoming?"
If the value in column G is "Won" or "Draw" then it won"t be "Upcoming" & will therefore be ignored.
Something is wrong in your posting: we chạy thử column G for won or draw so the thử nghiệm for Upcoming is redundant (I was obviously asleep when I read the post)!And this was pointed out in post #7.Post a tệp tin because the problem it is not as you describe it.
it was my fault i had made an error on my part ur original formula works as it should my fault i only realised when i stripped it down after coping the sheet lớn a new book an then saw the error thank you for every thing
You may not post new threadsYou may not post repliesYou may not post attachmentsYou may not edit your posts
Register To Reply
Forum Guru
Bạn đang xem: The formula you typed contains an error
One chạy thử is worth a thousvà opinions.
Xem thêm: Giá Bán Xe Toyota Prius Giá Tại Việt Nam, Giá Bán Xe Toyota Prius Chạy Xăng Điện
Register To Reply
FYI: an alternative sầu ....=COUNTIFS(F:F,"=" &A62,G:G,"=won")*3+COUNTIFS(F:F,"=" &A62,G:G,"=draw")If that takes care of your original question, please select Thread Tools from the menu link above sầu & mark this thread as SOLVED. Thanks.
The above works perfect khổng lồ bởi what i want but i need it lớn ignore "Upcoming"whisch is in column g also upcoming only changes ones a game is finished =SUMPRODUCT(($F$7:$F$44=$A62)*(($G$7:$G$44="Won")*3+($G$7:$G$44="Draw"))) - where & how would i get it to ignore $G$7:$G$44="upcoming?"
The above works perfect to lớn vị what i want but i need it lớn ignore "Upcoming"whisch is in column g also upcoming only changes ones a game is finished =SUMPRODUCT(($F$7:$F$44=$A62)*(($G$7:$G$44="Won")*3+($G$7:$G$44="Draw"))) - where và how would i get it lớn ignore $G$7:$G$44="upcoming?"
If the value in column G is "Won" or "Draw" then it won"t be "Upcoming" & will therefore be ignored.
Something is wrong in your posting: we chạy thử column G for won or draw so the thử nghiệm for Upcoming is redundant (I was obviously asleep when I read the post)!And this was pointed out in post #7.Post a tệp tin because the problem it is not as you describe it.
it was my fault i had made an error on my part ur original formula works as it should my fault i only realised when i stripped it down after coping the sheet lớn a new book an then saw the error thank you for every thing
You may not post new threadsYou may not post repliesYou may not post attachmentsYou may not edit your posts