array formula help please
 

i have a simple sumif formula that works on a single page, this one for
january:
=SUMIF(Jan!B4:B56,"=W",Jan!$G$4:$G$56)

how would i create the formula to work with sheets jan:dec?


thanks

--


Gary

array formula help please
 

simplest way would probably be to take what you already have, and just
duplicate it for each sheet with a "+" sign in between. i.e.:
=SUMIF(Jan!B4:B56,"=W",Jan!$G$4:$G$56) +
SUMIF(Feb!B4:B56,"=W",Feb!$G$4:$G$56) + SUMIF(Mar!B4:B56,"=W",Mar!$G$4:$G$56)
.....

Eddie O

"Gary Keramidas" wrote:


i have a simple sumif formula that works on a single page, this one for
january:
=SUMIF(Jan!B4:B56,"=W",Jan!$G$4:$G$56)

how would i create the formula to work with sheets jan:dec?


thanks

--


Gary

array formula help please
 

that was my last resort, if somebody wasn't able to come up with something
simpler

--


Gary


"Eddie O" wrote in message
...
simplest way would probably be to take what you already have, and just
duplicate it for each sheet with a "+" sign in between. i.e.:
=SUMIF(Jan!B4:B56,"=W",Jan!$G$4:$G$56) +
SUMIF(Feb!B4:B56,"=W",Feb!$G$4:$G$56) +
SUMIF(Mar!B4:B56,"=W",Mar!$G$4:$G$56)
....

Eddie O

"Gary Keramidas" wrote:


i have a simple sumif formula that works on a single page, this one for
january:
=SUMIF(Jan!B4:B56,"=W",Jan!$G$4:$G$56)

how would i create the formula to work with sheets jan:dec?


thanks

--


Gary