Sumifs range between multiple text string .

**Vandini.S** · 08-18-2015, 08:50 AM

Hi,

How do sumifs Between more than two text string in single cells.

Sample Data:

Text Date Value Type

Ford1 02/05/2015 1,266.59 Car
Ford1 02/05/2015 707.05 Car
Ford1 02/05/2015 413.19 Car
Ford1 02/05/2015 3,727.39 Car
Ford1 02/05/2015 368.41 Car
Ford1 02/05/2015 1,449.42 Car
Ford1 02/05/2015 575.3 Car

Honda1 29/05/2015 83.22 Car
Honda1 29/05/2015 63,096.91 Car
Honda2 02/05/2015 4,578.00 Car
Honda2 02/05/2015 6,578.00 Car
Honda3 04/05/2015 59.33 Car
Honda3 04/05/2015 268.52 Car
Honda3 04/05/2015 53.05 Car
Honda3 04/05/2015 153.79 Car

Desired Results:

Bike-Van-Car Desired Results:

Type May-15

Ford1-Ford2 8507.35

Hyundai1-Hyundai2-Hyundai3 74870.82

i want the sum of value against corresponding to the range and month.

file attached. someone help its appreciated.

**Joe Bushfield** · 08-18-2015, 08:57 AM

=SUMIFS($C$2:$C$112,$A$2:$A$112,"Honda*",$B$2:$B$112,">="&DATE(YEAR(J$2),MONTH(J$2),1),$B$2:$B$112,"<="&DATE(YEAR(J$2),MONTH(J$2)+1,1)-1)

**newdoverman** · 08-18-2015, 09:29 AM

The formula that you are looking for is probably this:

Formula:

Please Login or Register  to view this content.

I don't know how much of the date that you want for the calculation so I just included the month

Formula:

Please Login or Register  to view this content.

In this version, month and year are included:

Formula:

Please Login or Register  to view this content.

The entries between the { } are different for each of the three situations and have to be filled in manually due to your data set-up.

**Vandini.S** · 08-20-2015, 02:25 AM

newdoverman & Joe Bushfield

lot of thanks its working perfect and super tricks.

Sumifs range between multiple text string .

LinkBack

Thread Tools

Rate This Thread

Display

Sumifs range between multiple text string .

Re: Sumifs range between multiple text string .

Re: Sumifs range between multiple text string .

Re: Sumifs range between multiple text string .

Thread Information

Users Browsing this Thread

Similar Threads

Finding Multiple Text String Modes from a single range

[SOLVED] Sumifs multiple range

Search text string and return multiple results depending on content of text string

Can I use sumifs on a range with multiple columns?

[SOLVED] Sumifs with OR operator text string search in single cell...

[SOLVED] IF range of cells contains string of text, return contents of cell where string is found

SUMIFS with multiple sum range columns

Bookmarks

Bookmarks

Posting Permissions