sumif on 2 criteria with worksheetprotection enabled
 

read other posts, don't seem connect it with my little problem:

flat table filled by low-users, passwordprotection enabled, so VBA, macro or
pivot is out of the Q.

column1: project (XXX, YYY, ZZZ) (A)
column2: account (4100 4200...4900) (B)
column3: USD (C)
column4: EUR (D)
column5: GBP (E)

each next tab: overview per project, summary per account. On tab2: project
XXX all acount and only the sums of the columns 3,4,5 for the project/account.

simple solution possible?

If I've understood it sounds like you could use the SUMIF function although
you might need another column on the front sheet project&account
--

Simon


"Ed Wien 72" wrote:

read other posts, don't seem connect it with my little problem:

flat table filled by low-users, passwordprotection enabled, so VBA, macro or
pivot is out of the Q.

column1: project (XXX, YYY, ZZZ) (A)
column2: account (4100 4200...4900) (B)
column3: USD (C)
column4: EUR (D)
column5: GBP (E)

each next tab: overview per project, summary per account. On tab2: project
XXX all acount and only the sums of the columns 3,4,5 for the project/account.

simple solution possible?

got-it, thru other thread:

=SUM ( IF (( criteria1 )*( criteria2 ) ; SUMRANGE )
via array!

and it works!!!

"Ed Wien 72" wrote:

read other posts, don't seem connect it with my little problem:

flat table filled by low-users, passwordprotection enabled, so VBA, macro or
pivot is out of the Q.

column1: project (XXX, YYY, ZZZ) (A)
column2: account (4100 4200...4900) (B)
column3: USD (C)
column4: EUR (D)
column5: GBP (E)

each next tab: overview per project, summary per account. On tab2: project
XXX all acount and only the sums of the columns 3,4,5 for the project/account.

simple solution possible?