| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF with two conditions ?
I have 3 colums
colum A G7705 colum B 300 colum C Units I need sum the units in colum C if colum A & B = "G77053000" Can somone Help |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(A1:A10="G7705"),--(B1:B10=300),C1:C10)
Regards, Peo Sjoblom "Mestrella31" wrote: I have 3 colums colum A G7705 colum B 300 colum C Units I need sum the units in colum C if colum A & B = "G77053000" Can somone Help |
|
#3
|
|||
|
|||
|
Ok I did that & it worked, now when I try to get the data from another
worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$L$2:$L$10) "Peo Sjoblom" wrote: =SUMPRODUCT(--(A1:A10="G7705"),--(B1:B10=300),C1:C10) Regards, Peo Sjoblom "Mestrella31" wrote: I have 3 colums colum A G7705 colum B 300 colum C Units I need sum the units in colum C if colum A & B = "G77053000" Can somone Help |
|
#4
|
|||
|
|||
|
hard to tell since you don't say what the "wrong data" is...
However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#5
|
|||
|
|||
|
both coulums are text and I corss check the numbers, to correct sum is 16000
and i don't know were is piking up 7685 "JE McGimpsey" wrote: hard to tell since you don't say what the "wrong data" is... However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#6
|
|||
|
|||
|
Hi
try for each cell in column L the following formula =ISNUMBER(L2) this has to return TRUE for all cells -- Regards Frank Kabel Frankfurt, Germany "Mestrella31" schrieb im Newsbeitrag ... both coulums are text and I corss check the numbers, to correct sum is 16000 and i don't know were is piking up 7685 "JE McGimpsey" wrote: hard to tell since you don't say what the "wrong data" is... However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#7
|
|||
|
|||
|
False on both colums
"Frank Kabel" wrote: Hi try for each cell in column L the following formula =ISNUMBER(L2) this has to return TRUE for all cells -- Regards Frank Kabel Frankfurt, Germany "Mestrella31" schrieb im Newsbeitrag ... both coulums are text and I corss check the numbers, to correct sum is 16000 and i don't know were is piking up 7685 "JE McGimpsey" wrote: hard to tell since you don't say what the "wrong data" is... However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#8
|
|||
|
|||
|
Hi
then your column L does not really contain numeric values (though they may look like such). You have to convert them back to numbers first: - change the format of these cells to 'General' or a 'Number' format - copy an empty cell - select these values - goto 'Edit - Paste Special' and choose 'Add' Now the formula should work -- Regards Frank Kabel Frankfurt, Germany "Mestrella31" schrieb im Newsbeitrag ... False on both colums "Frank Kabel" wrote: Hi try for each cell in column L the following formula =ISNUMBER(L2) this has to return TRUE for all cells -- Regards Frank Kabel Frankfurt, Germany "Mestrella31" schrieb im Newsbeitrag ... both coulums are text and I corss check the numbers, to correct sum is 16000 and i don't know were is piking up 7685 "JE McGimpsey" wrote: hard to tell since you don't say what the "wrong data" is... However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#9
|
|||
|
|||
|
Thanks For Everything, It works Know...
MUCHAS GRACIAS de MEXICO "Frank Kabel" wrote: Hi try for each cell in column L the following formula =ISNUMBER(L2) this has to return TRUE for all cells -- Regards Frank Kabel Frankfurt, Germany "Mestrella31" schrieb im Newsbeitrag ... both coulums are text and I corss check the numbers, to correct sum is 16000 and i don't know were is piking up 7685 "JE McGimpsey" wrote: hard to tell since you don't say what the "wrong data" is... However, I'd start with making sure that my numbers in Actual!$L$2:$L$10 were really numbers, rather than numbers entered as Text (copy a blank cell, select your range, then choose Edit/Paste Special, selecting the Add and Values radio buttons). In article , "Mestrella31" wrote: Ok I did that & it worked, now when I try to get the data from another worksheet it gives me wrong data, do you know why? =SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$ L$2:$L$10) |
|
#10
|
|||
|
|||
|
Did you get a satisfactory answer to your question? If not, I have another
solution that does not use sum product "Mestrella31" wrote: I have 3 colums colum A G7705 colum B 300 colum C Units I need sum the units in colum C if colum A & B = "G77053000" Can somone Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range after 2 different conditions are met (2 colu. | Excel Discussion (Misc queries) | |||
| Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
| Sum or Sumif | Excel Discussion (Misc queries) | |||
Linear Mode
