Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for transferring data in rows to columns on two different Worksheets
I have data for two organizations (BBO and CCD) collected by week in rows in a sheet titled "Data".
The data collected is: Gross, Net and Value I want to present the data for each organization by week with the weeks presented in columns (see sheet "Summary") I tried a nested IF statement but it didn't work (See "Summary" sheet). I tried an INDEX / MATCH formula but couldn't get that to work either (see cell B3 on "SUMMARY" sheet). Expected value is $100 not "0". I welcome and appreciate your suggestions. Thanks in advance. Jim |
#2
|
|||
|
|||
Quote:
You could also use SUMIFS to do the same. |
#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 |
#4
|
|||
|
|||
Quote:
This link will explain it far better than I would... www.xldynamic.com/source/xld.SUMPRODUCT.html |
#6
|
|||
|
|||
|
Reply |
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 |