Forum Discussion

Copper Contributor

Sep 04, 2022

FILTER function

Hi, I have currently migrated from Googlesheets to EXCEL. I have an issue with the FILTER function, I have a simple formula that looks back at another sheet and returns any values less than...

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Sep 04, 2022

Lukereeves Would be helpful if you could share the formula.

Lukereeves
Copper Contributor
Sep 04, 2022
Riny_van_Eekelen

Oops

=FILTER('PB 3 WORKINGS'!B3:E16000,'PB 3 WORKINGS'!E3:E16000<0)

Column E3 is a sum of 2 other columns.
- Riny_van_Eekelen
  Platinum Contributor
  Sep 04, 2022
  Lukereeves The formula syntax seems to be correct and FILTER looks at the values of the cells to be included, not the formulas in those cells.
  
  You say the function "does not return a value". But you don't specify the result that is being returned. It can't be just nothing. Perhaps a #CALC! error, meaning no matching records were found. If so, you may add a third optional argument specifying what needs to be returned if no matches are found.
  
  Or do you get a dialogue box stating "There's a problem with this formula"? Perhaps you need you use a semi-colon rather than a comma to separate arguments in your local Excel set-up.