Sum range excluding multiple words

[bobski23]

In a Columbo voice. . . "Just one more thing please sir". . .

Is there a way of using sumif to tell excel

if the cell contains neither "petrol" or "toll" then put total in a different cell.

Im sorry to be a right typical noob but I can't seem to understand a lot of the posts here.

Theyre a bit too technical for me.

Thanks again.

Bob

[nasser]

In a Columbo voice. . . "Just one more thing please sir". . .

Is there a way of using sumif to tell excel

if the cell contains neither "petrol" or "toll" then put total in a different cell.

Im sorry to be a right typical noob but I can't seem to understand a lot of the posts here.

Theyre a bit too technical for me.

Thanks again.

Bob

I understand that you didn't got a reply ,because what you trying to do is make the excel read if the cell contains neither Petrol or Toll , that means it will calculate PETROL + TOLL in the petrol OR TOLL cell , like >>

Petrol London £10.00
Toll fee £4.50
Refreshmnts £6.00
Petrol York £20.00
Toll fee £4.50
Petrol Devon £30.00
Motor oil £25.00


Petrol = 69£ (Petrol + Toll)
Toll fee =69£ (Petrol + Toll)
Other = £

if you feel confused from the previous Formula you can try this one

=(SUMIF($A$1:$A$7,"*petrol*",$B$1:$B$7))

this one for Petrol , you can change the word to Toll or any other

*if you got it solved please don't forget to mark the thread as SOLVED
Good Luck

[arthurbr]

Nasser

please do NOT quote entire posts unnecessarily - They clog the forum and make threads hard to read

Bobski, I started a new thread with your post

The original thread can be found here

[arthurbr]

To solve your problem, try

Please Login or Register  to view this content.

In 2007 another version of sumproduct called SUMIFS can be used. I'm not familiar with the syntax though

[Haseeb Avarakkan]

Hello, Also use this;

=SUM(SUMIF(A:A,{"*Petrol*","*Toll*"},B:B))

Where A:A is the values like, petrol, toll etc...

B:B is the amount column.

[bobski23]

Thanks once again.

I was thinking about the "other" column. I'm sure on the other post yesterday someone was helping but I didn't get it.

But, I think I may have a slight clue, If someone could verify this . . .

I get excel to calculate the "petrol" and "Toll" separately then add them in another cell.
Then excel adds the total of the column.
Then "Other" would be the difference between the added petrol and toll and the total.

Hmmm this excel thingy is quite fun in a kind of confusing way.

Many thanks to everyone.

Have a great day y'all.

Bob

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save