×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Count Cells with Data

Count Cells with Data

Count Cells with Data

(OP)
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
 

RE: Count Cells with Data

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

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.

RE: Count Cells with Data

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

RE: Count Cells with Data

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.

RE: Count Cells with Data

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.

RE: Count Cells with Data

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

 

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

RE: Count Cells with Data

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources