Forum Discussion

Bianca Gordon's avatar
Bianca Gordon
Copper Contributor
Jan 10, 2018

Extracting From Raw Data Sheet

Hi,    There are 4 columns from my raw data sheet that i need to extract data from.  Here's what I'm looking to create.     From the Raw Data sheet, If Column A(Name) is xyz AND Column B ...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 10, 2018

Hi Bianca,

 

You may try like

=SUMPRODUCT((name=xyz)*(date>=datestart)*(date<=dateend)*(term=xyz)*(D1:D1000))

 

Bianca Gordon's avatar
Bianca Gordon
Copper Contributor
Jan 10, 2018

Thanks Sergei, 

 

I am getting an formula error. See below. Let me know if you need snapshots of anything. 

 

Thanks! 

 

=SUMPRODUCT(('Term Goals Data2'!U:U=Sheet4!A3)*( 'Term Goals Data2'!Z:Z<=6/18/2017)*( 'Term Goals Data2'!Z:Z<=6/24/2017)*('Term Goals Data2'!I:I=2_Fall 2017)*('Term Goals Data2'!W:W))