| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
That is what I was looking for. I wasn't familiar with the sumproduct formula. Thanks!
One question though, in the formula =SUMPRODUCT(--(DATA!$A$2:$A$38=$A2)*(DATA!$B$2:$B$38=B$1),DATA!$ C$2:$C$38) what are the "--" before (DATA!$A$@...) for? Thanks, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transferring data between worksheets | Excel Programming | |||
| Transferring data between worksheets? | Excel Programming | |||
| Transferring/Merging Data Between Worksheets | Excel Discussion (Misc queries) | |||
| Transferring data between worksheets | Excel Worksheet Functions | |||
| Transferring data between worksheets | Excel Programming | |||
Threaded Mode
