I am trying to sum 5 sheets into a master sheet by client using the following
formula, I am not sure of how to add all the sheets in the workbook. This is
what I got so far for the master sheet

=SUMIF(Sheet1!A:A,"approved",Sheet1!C:C)

and that works fine for one sheet, how do I apply it so it adds all five
sheets at one time for "approved"
Please help.!
thank you
--
Louie