Formula for transferring data in rows to columns on two different Worksheets

[PDX_Jim]

I have data for two organizations (BBO and CCD) collected by week i
rows in a sheet titled "Data".
The data collected is: Gross, Net and Valu

I want to present the data for each organization by week with the week
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 eithe
(see cell B3 on "SUMMARY" sheet). Expected value is $100 not "0"

I welcome and appreciate your suggestions

Thanks in advance

Ji

+-------------------------------------------------------------------
|Filename: Sample File.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=428
+-------------------------------------------------------------------

 

[Spencer101]

I have data for two organizations (BBO and CCD) collected by week i
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 week
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 eithe
(see cell B3 on "SUMMARY" sheet). Expected value is $100 not "0".

I welcome and appreciate your suggestions.

Thanks in advance.

Jim

I think this is what you mean.

You could also use SUMIFS to do the same

+-------------------------------------------------------------------
|Filename: Sample File (2).zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=429
+-------------------------------------------------------------------