Thank you for the help. I'm a little new at this, so I'm not sure where to
insert the "If" statement into the existing formula and/or what I should be
entering in the parenthesis after choose.

"T. Valko" wrote:

+SUMPRODUCT(--(E53=$A$24),--(G53=$B$24),$D$24)
Can be expressed as:
+(AND(E53=$A$24,G53=$B$24)*$D$24)

Or even:

+(E53=$A$24)*(G53=$B$24)*$D$24


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=IF(G53="","",CHOOSE(........))

You can save a few keystrokes by replacing that last SUMPRODUCT:

+SUMPRODUCT(--(E53=$A$24),--(G53=$B$24),$D$24)

Can be expressed as:

+(AND(E53=$A$24,G53=$B$24)*$D$24)

--
Biff
Microsoft Excel MVP


"jonssmaster" wrote in message
...
I have the following formula that works just fine, except that I need help
with the formula when G33 is blank. I would like the formula cell (H33)
to
remain blank if no value has been entered. Any suggestions?

=CHOOSE(SUMPRODUCT(--($A$1:$A$17=E53),--(G53=$B$1:$B$17),$D$1:$D$17)+SUMPRODUCT(--(E53=$A$19:$A$23),--(G53$B$19:$B$23),--(G53<=$C$19:$C$23),$D$19:$D$23)+SUMPRODUCT(--(E53=$A$24),--(G53=$B$24),$D$24),"Inconsistent","Does
Not Meet","Successful","Excellent","Exceptional","N/A")