Look up for the value in column and return sum if condition match

**KRIXXXX** · 08-24-2022, 01:47 PM

Look up for the value in column and return sum if condition match

I am attaching excel sheet for reference

**Fluff13** · 08-24-2022, 01:53 PM

How about

Formula:

Please Login or Register  to view this content.

**oeldere** · 08-24-2022, 01:57 PM

With a pivot table.

See the attached file.

**KRIXXXX** · 08-24-2022, 02:29 PM

Originally Posted by Fluff13

How about

Formula:

Please Login or Register  to view this content.

It works as I expected. Thanks for the solution.

It will be appreciated if you can give the lookup (index, match or any other) solution also, because I have similar cases where there is text data instead of account numbers.

**Fluff13** · 08-24-2022, 02:37 PM

Glad to help & thanks for the feedback.
If you want to count text values, just use countifs instead of sumifs.

Look up for the value in column and return sum if condition match

LinkBack

Thread Tools

Rate This Thread

Display

Look up for the value in column and return sum if condition match

Re: Look up for the value in column and return sum if condition match

Re: Look up for the value in column and return sum if condition match

Re: Look up for the value in column and return sum if condition match

Re: Look up for the value in column and return sum if condition match

Thread Information

Users Browsing this Thread

Similar Threads

Return percentage value if match two cell ranges text value same with condition

[SOLVED] Using Index/Match to return a specific value with a condition

To return the value of the cell in a row if it match the condition

[SOLVED] Search column for condition(s) and return "1" if match

[SOLVED] Match string between cells in two tables and return a value based on condition

[SOLVED] Lookup in columns and return if the condition is match

Match two condition and return a value

Bookmarks

Bookmarks

Posting Permissions