Count Cells with Data

[Harley78]

I am trying to write a formula, but i am stuck.

MAIN SHEET - In column A, each cell contains order# (text or number) Then in column EE there will be a month that this order came in.

Now on my SUMMARY SHEET I have the below formula in C191 (B191 represents the month), but not getting the correct amount. Currently I have 108, but the below is coming up 11041398.

my current formula is
=SUMIF('Orders in 2008'!$EE:$EE,B191,'Orders in 2008'!$A:$A)


My summary should look like this

column b column c

Month CONFIGURATIONS
January 16
February 6
March 5
April 22
May 4
June 7
July 2
August 19
September 16
October 11
November 0
December

Hopefully this will give an idea what I am trying to achieve and I explained it clearly. If not let me know.

Thanks for your help.

Bill

 

[electricpete]

I you have order numbers in column A of sheet "orders in 2008", then you are summing the order numbers (!) with the following code:

=SUMIF('Orders in 2008'!$EE:$EE, B191, 'Orders in 2008'!$A:$A)

Try deleting the 3rd argument if you just want to count the records matching your criteria.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[Harley78]

thats weird, it calculating, 11041398 and not 16. Is there something I am doing wrong?

 

[electricpete]

Yes you are doing something wrong. The 3rd argument tells sumif what column to sum, and you are telling it to sum the serial numbers in column A!

Delete the 3rd argument:

Change FROM
=SUMIF('Orders in 2008'!$EE:$EE, B191, 'Orders in 2008'!$A:$A)
TO
=SUMIF('Orders in 2008'!$EE:$EE)

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

Sorry, I deleted one too many arguments. Should have said:

Change FROM
=SUMIF('Orders in 2008'!$EE:$EE, B191, 'Orders in 2008'!$A:$A)
TO
=SUMIF('Orders in 2008'!$EE:$EE, B191)


=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

Come to think of it... countif is more appropriate than sumif.



=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

That is...
=Countif('Orders in 2008'!$EE:$EE, B191)

=====================================
Eng-tips forums: The best place on the web for engineering discussions.