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:a22110)*(b2:b22="x"))

--
Don Guillett
SalesAid Software

"metaltecks" wrote in message
...
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

I still get an error, but do you think calcuating it as an array will help out?

"metaltecks" wrote:

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