software

I'm having problems trying to get my final answer, maybe you can help.

I have a Column that has numbers ranging from 1-300.
In the next column I have a To Do Column, that simplies has an X mark.
And in the column next to it, I have a Completed Column, that also has an X
to it.

What I'm trying to do is caluclate the number of times I have gone over 110.
I used a countif to get that number 87. I now need to calculate, the number
of To Do and number of Completed out of this 87. I've calculated the totals
for both these columns, but I just can't seem to know how to link them. I
think using an If statement would do it, but I can't get the answer I want.

Please help.

Thank you

maybe
=sumproduct((a2:a22gt;110)*(b2:b22=quot;xquot;))

--
Don Guillett
SalesAid Software

quot;metaltecksquot; gt; wrote in message
news
gt; I'm having problems trying to get my final answer, maybe you can help.
gt;
gt; I have a Column that has numbers ranging from 1-300.
gt; In the next column I have a To Do Column, that simplies has an X mark.
gt; And in the column next to it, I have a Completed Column, that also has an
gt; X
gt; to it.
gt;
gt; What I'm trying to do is caluclate the number of times I have gone over
gt; 110.
gt; I used a countif to get that number 87. I now need to calculate, the
gt; number
gt; of To Do and number of Completed out of this 87. I've calculated the
gt; totals
gt; for both these columns, but I just can't seem to know how to link them. I
gt; think using an If statement would do it, but I can't get the answer I
gt; want.
gt;
gt; Please help.
gt;
gt; Thank you
I still get an error, but do you think calcuating it as an array will help out?

quot;metaltecksquot; wrote:

gt; I'm having problems trying to get my final answer, maybe you can help.
gt;
gt; I have a Column that has numbers ranging from 1-300.
gt; In the next column I have a To Do Column, that simplies has an X mark.
gt; And in the column next to it, I have a Completed Column, that also has an X
gt; to it.
gt;
gt; What I'm trying to do is caluclate the number of times I have gone over 110.
gt; I used a countif to get that number 87. I now need to calculate, the number
gt; of To Do and number of Completed out of this 87. I've calculated the totals
gt; for both these columns, but I just can't seem to know how to link them. I
gt; think using an If statement would do it, but I can't get the answer I want.
gt;
gt; Please help.
gt;
gt; Thank you