SUM IF Formula issue

[Obeitia]

Hiya,

I am trying sum revenue from a database using 3 similar keywords by month

Travel Suit
Suit
A Suit To Travel in

I am using the following formula =SUMIF($A:$C,"Travel Suit",$C:$C)+SUMIF($A:$C,8,$B:$B) but is not working
I attached the docuement in case could be helpful what I am doing

Would be appreciated some help on this

Regards

Olatz

[dflak]

I assume you want a count of the number of times the word, "Suit" shows up in columns A:C?

If so, the formula is COUNTIFS($A:$C,"*Suit*")

[PeteABC123]

Thought: depending on the number of records analyzed and the capabilities of your computer, it may be in your interest to better define a range in terms of the number of rows analyzed. Having it look through over a million rows in each column may not be desirable; it could bog things down. Might use a range, such as $A$2:$C$10000 if that captures all your data to be analyzed. . .or similar.

Pete

[Tony Valko]

I attached the docuement in case could be helpful what I am doing

Don't see an attachment.

[Tony Valko]

Duplicate thread:

https://www.excelforum.com/showthread.php?t=1158855

[Obeitia]

hiya, thank for your answer, yeah is a duplicate thread, I clicked send thread twice