| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMPRODUCT Works Sometimes Why
I have use this formula before, but i try it again on another sheet and now
it does not work. This Works: =SUMPRODUCT(('Dec Actual'!$F$2:$F$100="0103")*('Dec Actual'!$G$2:$G$100=B101)*('Dec Actual'!$I$2:$I$100)) This does not: =SUMPRODUCT(('Source'!A5:A350="A")*(Source'!B5:B35 0=A8)*('Source'!AM5:AM350)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Convert excel files to works 8 spreadsheet | Excel Discussion (Misc queries) | |||
| Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) | |||
| I would like to make a schedule for my dept. Who works what days . | Charts and Charting in Excel | |||
Threaded Mode
