formula?

  • Thread starter Thread starter Philea_92
  • Start date Start date
P

Philea_92

Hi,

If anyone can help i would greatly appreciate it. I have a sheet whic
needs a formula to complete.

I need a formula like:

sum(sheets 1 to 3 where cell range a1:a100 ="login")AND(sheets 1 to
where cell range c1:c100 = "sdu group)

divide this all by

count(sheets 1 to 3 where cell range a1:a100 ="login")AND(sheets 1 t
3 where cell range c1:c100 = "sdu group)

thus hopefully giving me an average figure.


can you help
 
Hi
some solutions:
1. Harlan Grove showed a formula approach for a
conditional sum accross
multiple worksheets. Have a look at this thread
http://tinyurl.com/2manj

2. You may also try to download the free add-in
Morefunc.xll
(http://longre.free.fr/english). The function THREED
converts a 3D
array to a 2D array. e.g. you may use the following formula
=SUM((THREED('sheet1:sheet10'!A1:A1000)="condition
one")*(THREED('sheet12:sheet10'!B1:B1000)))

enter this as array formula (CTRL+SHIFT+ENTER). This will
sum all
values from column Bin which column A contains our criteria
 
Thanks but I am having trouble accessing the links; keeps on coming bac
with "page cannot be displayed"

any other ideas would be appreciated :
 
Back
Top