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
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
CODE
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Count Cells with Data
RE: Count Cells with Data
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
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
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Count Cells with Data
=Countif('Orders in 2008'!$EE:$EE, B191)
=====================================
Eng-tips forums: The best place on the web for engineering discussions.