| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum IF ?
I need to add on to my question from the other night. Here is the example
A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
=IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None")
Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
I tired it and it said "Your formula is missing --) or (. Check the formula
and add in the appropiate place... I tried adding in a parenthesis at the end but it said my formula contained an error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"} ,Barrett!A12:A23),"Yes","None")) Do I need the (SUM and the (Sumif? "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
This formula should work
=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23)),"Yes","None") Do I need the (SUM and the (Sumif? yes, you do. "kristap" wrote: I tired it and it said "Your formula is missing --) or (. Check the formula and add in the appropiate place... I tried adding in a parenthesis at the end but it said my formula contained an error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"} ,Barrett!A12:A23),"Yes","None")) Do I need the (SUM and the (Sumif? "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
Ooops! My mistake. I forgot the closing ")" for the SUM function.
Try it like this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23)),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I tired it and it said "Your formula is missing --) or (. Check the formula and add in the appropiate place... I tried adding in a parenthesis at the end but it said my formula contained an error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"} ,Barrett!A12:A23),"Yes","None")) Do I need the (SUM and the (Sumif? "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
I tired that and it said i didn't have enough --) or (. so i added a
parenthesis at the end and it didn't work, said the formula contained an error. This is what I have =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None")) "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
Ooops! My mistake. I forgot the closing ")" for the SUM function.
Try it like this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23)),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I tired that and it said i didn't have enough --) or (. so i added a parenthesis at the end and it didn't work, said the formula contained an error. This is what I have =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None")) "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
Awesome, Thank you so much....... Thanks to you too toothless momma.....
I appreciate all your help "T. Valko" wrote: Ooops! My mistake. I forgot the closing ")" for the SUM function. Try it like this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23)),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I tired it and it said "Your formula is missing --) or (. Check the formula and add in the appropiate place... I tried adding in a parenthesis at the end but it said my formula contained an error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"} ,Barrett!A12:A23),"Yes","None")) Do I need the (SUM and the (Sumif? "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum IF ?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "kristap" wrote in message ... Awesome, Thank you so much....... Thanks to you too toothless momma..... I appreciate all your help "T. Valko" wrote: Ooops! My mistake. I forgot the closing ")" for the SUM function. Try it like this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23)),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I tired it and it said "Your formula is missing --) or (. Check the formula and add in the appropiate place... I tried adding in a parenthesis at the end but it said my formula contained an error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"} ,Barrett!A12:A23),"Yes","None")) Do I need the (SUM and the (Sumif? "T. Valko" wrote: =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0 ,"Yes","None") Maybe this: =IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett! A12:A23),"Yes","None") -- Biff Microsoft Excel MVP "kristap" wrote in message ... I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 4x2 HD 2 3x4 CD I need a calculation where it says "Yes" in the cell (not a number) for all the HD and the CD.... HD is 0 but I still need the yes because there is a CD....This is what i have but how do I get it to figure the cd as well? E12:E23 is the type and A12:A23 is the count. I have tried a few different things to add in the CD part but none seem to work for me. =IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)0, "Yes","None") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
