Excel function sumif help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel function sumif help

09-03-2021, 12:08 AM

ganesang

Windows XP Excel function sumif help

Office 2016

Competent Performer

Join Date: Jul 2018

Posts: 170

Hi thanks for the replay!!

I think the left function use to sort out my issue

LEFT(D116,FIND("#",SUBSTITUTE(D116,":","#",2))-1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel function help	ganesang	Excel Programming	4	09-20-2021 01:48 AM
Data connection problem excel/sharepoint using an SUMIF array	mwestra74	Excel Programming	10	11-28-2017 06:26 PM
Ms Excel 2016 IF function	IFnoob	Excel	1	08-13-2016 11:34 PM
Excel function issue	Nobody	Excel	1	06-30-2014 12:26 PM
Excel Function	co-lay	Excel	3	02-13-2012 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 AM.