Sum with Criteria across worksheets (Excel 2003)

Topic

New Reply

Is it possible to use Sumproduct or Sumif across worksheets in a workbook?
for example :

=SUMPRODUCT(–(Sheet1:Sheet3!$A$2:$D$10=”Text”),–(Sheet1:Sheet3!$A$2:$D$10>=5),Sheet1:Sheet3!C2:C10)
or using SUMIF
=SUMIF(Sheet1:Sheet3!A2:A10,”>5″,Sheet1:Sheet3!B2:B10)

TIA

cheers, francis

Reply | Quote

Replies

See post 694,460.

Reply | Quote

Thanks for the link.

cheers, francis

Reply | Quote