| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct using Tables
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") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| Two new tables from one | Excel Discussion (Misc queries) | |||
| Tables | Excel Worksheet Functions | |||
Threaded Mode
