Posted to microsoft.public.excel.worksheet.functions
|
|
SUM VALUES on MULTIPLE SHEETS
See
http://www.mcgimpsey.com/excel/threedsumif.html
In article
,
lotivbarjoh wrote:
I need a formula to sum values in the same column on multiple sheets
if it finds a specified value in the same row of a different column.
SUMIF works fine if I select a single sheet but as soon as I select
multiple sheets it errors and returns #VALUE
|