Array
 

I wonder, is there a way to create a 3 dimensional array or another method to
it?

Array
 

Depends on what you want to do, how about a concrete question? If you mean
like working over multiple sheets there are way sof doing things that MS
never knew were possible.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"metaltecks" wrote in message
...
I wonder, is there a way to create a 3 dimensional array or another method
to
it?

Array
 

Ok,
I have a column A called time . The values in these cells range from 0-500.
In Column B, I have a column called Student. Cell Values are x's.
In Column C, I have a column called Teacher. Cell Values are x's.
In Column D, I have a column called project. The values in these cells are
x's.
In Column E, I have a column called completed. Cell Values are x's.
In Column F, I have a column called pending. Cell Values are x's.

What i want to know is how can I determine the number of times a student has
a project, completed, and pending that is over 100 minutes.

I created an array to calculate the total number of times a student has gone
over 100 minutes. The formula is {=sum((a2:20100)*(b2:b200))} But when I
try to add another range, I get an error.

Please help, when i have got this formula, the rest if just plugging in
different values.

Thank you

Array
 

As long as the ranges are of equal size like in

=SUMPRODUCT(--(A2:A20100),--(B2:B200),--(D2:D200))

it will work, post the one that didn't work

that above will count the conditions where A100 AND B 0 AND D 0
if you want where A 100 AND B OR C 0 you can use

=SUMPRODUCT(--(A2:A20100),--((B2:B200)+(D2:D200)0))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"metaltecks" wrote in message
...
Ok,
I have a column A called time . The values in these cells range from
0-500.
In Column B, I have a column called Student. Cell Values are x's.
In Column C, I have a column called Teacher. Cell Values are x's.
In Column D, I have a column called project. The values in these cells are
x's.
In Column E, I have a column called completed. Cell Values are x's.
In Column F, I have a column called pending. Cell Values are x's.

What i want to know is how can I determine the number of times a student
has
a project, completed, and pending that is over 100 minutes.

I created an array to calculate the total number of times a student has
gone
over 100 minutes. The formula is {=sum((a2:20100)*(b2:b200))} But when I
try to add another range, I get an error.

Please help, when i have got this formula, the rest if just plugging in
different values.

Thank you