Array

M

metaltecks

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

Peo Sjoblom

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
 
M

metaltecks

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:20>100)*(b2:b20>0))} 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
 
P

Peo Sjoblom

As long as the ranges are of equal size like in

=SUMPRODUCT(--(A2:A20>100),--(B2:B20>0),--(D2:D20>0))

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

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

=SUMPRODUCT(--(A2:A20>100),--((B2:B20>0)+(D2:D20>0)>0))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Top