Hi,
In my sum total, is it possible to exclude an items value by its name in a different column?
For example: Exclude the cost of the Banana" (B3) from the running total (C6)
test.png
I hope that's clear
Many thanks
Hi,
In my sum total, is it possible to exclude an items value by its name in a different column?
For example: Exclude the cost of the Banana" (B3) from the running total (C6)
test.png
I hope that's clear
Many thanks
Last edited by Dobbies; 03-04-2020 at 01:01 PM.
Hi,
Like this?
Formula:Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi Doobies,
The SumIf() formula will work for you. In your example put this in C6
Formula:Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
=SUMIFS(C1:C4,B1:B4,"<>bannana")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Many thanks to you all for your help. Works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks