=SUMPRODUCT(('YTD PROD HRS'!$F$5:$F$65536=$C$46,$C$45)*('YTD PROD
HRS'!$C$5:$C$65536='PHASE HRS MONTHLY'!B48)*('YTD PROD
HRS'!$B$5:$B$65536='PHASE HRS MONTHLY'!$A$2)*('YTD PROD
HRS'!$B$5:$B$65536<='PHASE HRS MONTHLY'!$A$3)*'YTD PROD HRS'!$D$5:$D$65536)

I am trying to get some answers if my hours are equal to either of two
criteria, in the first statement, obviously I am not stating it properly in
=c45, c46 I tried, or, but that did not work either. Should I just be giving
it another set (f5:f65536=c45)? I actually wanted to tell it to sum
everything in those ranges that ended with "roads" but cannot get the
wildcard down. In access it's, like, but there doesn't seem to be anything
the same in excel. Thanks I don't think I would get anywhere without
everyone's fantastic input.

=SUMPRODUCT((ISNUMBER(MATCH('YTD PROD HRS'!$F$5:$F$65536,$C$45,$C$46,0)*the
rest of your formula


"Arlene" wrote:

=SUMPRODUCT(('YTD PROD HRS'!$F$5:$F$65536=$C$46,$C$45)*('YTD PROD
HRS'!$C$5:$C$65536='PHASE HRS MONTHLY'!B48)*('YTD PROD
HRS'!$B$5:$B$65536='PHASE HRS MONTHLY'!$A$2)*('YTD PROD
HRS'!$B$5:$B$65536<='PHASE HRS MONTHLY'!$A$3)*'YTD PROD HRS'!$D$5:$D$65536)

I am trying to get some answers if my hours are equal to either of two
criteria, in the first statement, obviously I am not stating it properly in
=c45, c46 I tried, or, but that did not work either. Should I just be giving
it another set (f5:f65536=c45)? I actually wanted to tell it to sum
everything in those ranges that ended with "roads" but cannot get the
wildcard down. In access it's, like, but there doesn't seem to be anything
the same in excel. Thanks I don't think I would get anywhere without
everyone's fantastic input.

If you want to match with something ending in "roads" you could use:

.... (RIGHT(range,5)="roads") ...

as one of your comparators.

Hope this helps.

Pete

On Jul 13, 11:54 pm, Arlene wrote:
=SUMPRODUCT(('YTD PROD HRS'!$F$5:$F$65536=$C$46,$C$45)*('YTD PROD
HRS'!$C$5:$C$65536='PHASE HRS MONTHLY'!B48)*('YTD PROD
HRS'!$B$5:$B$65536='PHASE HRS MONTHLY'!$A$2)*('YTD PROD
HRS'!$B$5:$B$65536<='PHASE HRS MONTHLY'!$A$3)*'YTD PROD HRS'!$D$5:$D$65536)

I am trying to get some answers if my hours are equal to either of two
criteria, in the first statement, obviously I am not stating it properly in
=c45, c46 I tried, or, but that did not work either. Should I just be giving
it another set (f5:f65536=c45)? I actually wanted to tell it to sum
everything in those ranges that ended with "roads" but cannot get the
wildcard down. In access it's, like, but there doesn't seem to be anything
the same in excel. Thanks I don't think I would get anywhere without
everyone's fantastic input.