Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mestrella31
 
Posts: n/a
Default 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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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   Report Post  
Mestrella31
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Mestrella31
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Mestrella31
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Mestrella31
 
Posts: n/a
Default

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   Report Post  
Tucson Guy
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sum a range after 2 different conditions are met (2 colu. Holly B. Excel Discussion (Misc queries) 3 December 21st 04 04:47 PM
Sum(if ... multiple conditions ... Interpretation? Ken Excel Discussion (Misc queries) 6 December 16th 04 11:23 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 11:12 PM
Summarize data with multiple conditions OkieViking Excel Discussion (Misc queries) 1 December 16th 04 10:17 PM
Sum or Sumif Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 10:56 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"