| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT can I use to get data from 2 worksheets in same wkBK
Hi there,
Can anyone help me to get this formula to work please? I want to count numbers of passes from two different worksheets "All" and "Bob" =SUMPRODUCT((All!$A$2:$A$5016=$A9)*(Bob!$A$2:$A$50 16=$A9)*(All!$K$2:$K$5016=4)*(Bob!$I$2:$I$2016=4)* (All!$F$2:$F$5016<=$D$4)*(Bob!$F$2:$F$2016<=$D$4)) I get #N/A Grateful for any help Cheers -- Mifty |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy records with specific text from one wkbk to another | Excel Worksheet Functions | |||
| Can't Alt Tab from wkbk to wkbk Help! | Excel Discussion (Misc queries) | |||
| How do I replicate an area of a SS onto another sheet in same wkbk | Excel Discussion (Misc queries) | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| looking for way to name columns (across sheets in wkbk) | New Users to Excel | |||
Threaded Mode
