Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |