Hi,

Newbie question: On sheet 2, I have a table from A1:K5000:

A (Project ID) B (Department) ....... K (Sum of hours)
abc art 15
bac prog 22
cba art 32

On sheet 1, I'm creating a sumup table and want to sum automatically the
hours from column K on sheet 2 from two criterias that i choose in sheet 1.

Sum all hours from project ABC of the art department from the data of Sheet 2:

Tried many things
like...=SUMPRODUCT(Sheet2!A2:K10001=A7,Sheet1!H7,S heet2!K2:K10001) but it
doesn't work.

Please help...thxs in advance.

Paul