Xlookup return sum of values in four columns

**fpt264** · 02-03-2023, 10:09 AM

Good morning,

I am trying to do an Xlookup in the range (B6:B20) and return the sum of the values in columns E,H,K,and N. Would appreciate some help.

Thanks

**Pepe Le Mokko** · 02-03-2023, 10:15 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Fluff13** · 02-03-2023, 10:24 AM

What version of Excel are you using? Your profile shows 2016 which doesn't have XLOOKUP

**fpt264** · 02-03-2023, 11:01 AM

Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit

**Fluff13** · 02-03-2023, 11:06 AM

Ok, how about like

Formula:

Please Login or Register  to view this content.

**fpt264** · 02-03-2023, 11:33 AM

That works. Thank you very much Fluff13!!

**Fluff13** · 02-03-2023, 11:38 AM

Glad to help & thanks for the feedback.

Xlookup return sum of values in four columns

LinkBack

Thread Tools

Rate This Thread

Display

Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Re: Xlookup return sum of values in four columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Can Xlookup return multiple values?

[SOLVED] XLOOKUP with multiple search criteria and multiple return values

[SOLVED] XLOOKUP Dynamic Return Value

Formula to return first value - XLOOKUP not doing the job

[SOLVED] Query on using XLOOKUP to return a value just once

[SOLVED] Xlookup several columns with multiple lookup values

Xlookup return maximum value

Bookmarks

Bookmarks

Posting Permissions