Related:

- Sum a range only if certain text in another
- Apple airtag range - Guide
- Sum column if another column equals ✓ - Excel Forum
- Check sum error - Guide
- Sum sum disney - Download - Puzzle
- Wimax frequency range - Guide

## 1 response

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Aug 27, 2009 at 09:25 PM

Aug 27, 2009 at 09:25 PM

your information is not complete

I assume the five text strings are in H8 to H12

and in I6 to I12 there are some numbers

now use this formula

=SUM(IF(H8:H12="CRM",I8:I12))

This is ana rray formula so INVOKE THIS FORMULA BY HITTING

CONTROL+SHIFT+ENTER.

I assume the five text strings are in H8 to H12

and in I6 to I12 there are some numbers

now use this formula

=SUM(IF(H8:H12="CRM",I8:I12))

This is ana rray formula so INVOKE THIS FORMULA BY HITTING

CONTROL+SHIFT+ENTER.

Aug 28, 2009 at 01:09 AM

You know I was sure I tried that. Must have made a dumb error in the formula somewhere. It was 4am my time.

I know... excuses, excuses. Knew it was an easy one. Thanks again, much appreciated.

Feb 14, 2012 at 02:53 PM

=sum(vlookup("CRM",C8:i12,5, false),vlookup("CRM",C8:i12,6, false))