Hi Community,
See the export I have set here, with a set of test data:
Test export.xls
I'm currently wanting to use the SUMIF formula of the column 'Reference'
However, the criteria for the formula I want to use is:
"B2B Delivery v2.0"
There are two tasks related to this project:
BEV01 - B2B Delivery v2.0 - Additional (Project - BEV01 - B2B Delivery v1.0)
&
BEV01 - B2B Delivery v2.0 - Engineering (Project - BEV01 - B2B Delivery v1.0)
As these 2 entries contain the text "B2B Delivery v2.0" - is there a way to do a search to see if a cell contains the text "B2B Delivery v2.0"?
Thanks
Tony
Bookmarks