Re: Sum with IF
- From: "Fred Smith" <fsmith11@xxxxxxxxxx>
- Date: Fri, 8 Feb 2008 19:11:35 -0600
So what we hear you saying is you don't want any more help. If that wasn't your intention, then post back with more information, like, what didn't work -- error message? wrong result? Also, the easiest way to more clearly explain the solution you are looking for is to give examples.
Regards,
Fred.
"Jane" <Jane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3CF91195-83C5-460F-8DF5-92A76DC62FFA@xxxxxxxxxxxxxxxx
yeah, it didn't work :(
"Jane" wrote:
Ok, so i have 1 thru 999 worksheets and i need a sum of IF formulas. But
SUMIF doesn't do what i need it to... I have IF('1'!B72,'1'!E2,0) what i
want is =SUM(IF('1'!B72,'1'!E2,0):IF('999'!B72,'999'!E2,0)) but it won't
let me do that. Do you understand my question?
Thanks!
.
- Follow-Ups:
- Re: Sum with IF
- From: Jane
- Re: Sum with IF
- Prev by Date: Re: Is there a macro i can use to copy a cell +1
- Next by Date: RE: How do i prevent the 000's in the beginning of an entry from dropp
- Previous by thread: Re: Sum with IF
- Next by thread: Re: Sum with IF
- Index(es):
Relevant Pages
|
