Microsoft Office Forums - View Single Post - Using IF AND and VLOOKUP

Thread: Using IF AND and VLOOKUP

View Single Post

Old

11-14-2017, 07:27 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Try:

=SUMIFS(Driving_Style[[Distance Travelled (km)]:[Distance Travelled (km)]],Driving_Style[[Registration]:[Registration]],$B3,Driving_Style[[Date]:[Date]],E$2)

copied down and across

Reply With Quote