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))

 

Resources