| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct question
I have this equation:
=SUMPRODUCT(--(Y$2:Y$80=Y83),--(Z$2:Z$80=Z83),--(AA$2:AA$80=AA83)) I want to modify it so that it will work only if AC$2:AC$80="ABC". What do I need to do? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct Question | Excel Discussion (Misc queries) | |||
| Sumproduct Question | Excel Discussion (Misc queries) | |||
| Question about sumproduct | Excel Discussion (Misc queries) | |||
| Question about sumproduct | Excel Discussion (Misc queries) | |||
| sumproduct question | Excel Worksheet Functions | |||
Threaded Mode
