Sep 21 2018 08:20 AM - edited Sep 21 2018 08:21 AM
Hi Guys,
I would like to use SUMIF, if possible, to add up a column but to exclude values when a corresponding cell contains the text "In Flight Relief". Can anybody help?
Sep 21 2018 06:12 PM
Sep 21 2018 11:11 PM
Thanks for your response Lorenzo.
I think my query may have been unclear. If the column I want to sum is M I would like the function to SUM, but exclude values within column M when there is specific text in a corresponding cell (let’s say column Z).
I know how use SUMIF to exclude the values when the corresponding cell has any unspecified text but I would like to exclude those cell with specific text.
Thanks again.
Sep 21 2018 11:30 PM - edited Sep 21 2018 11:37 PM
I prepared a sample -
see if you can work something out of it.
thanks..
Sep 21 2018 11:32 PM
Sep 21 2018 11:48 PM - edited Sep 21 2018 11:58 PM
I think I solved your sumif - pls see attached file
thanks..
Sep 22 2018 12:01 AM
Sep 22 2018 12:22 AM
SolutionSep 23 2018 09:23 AM
Thank you very much Lorenzo.
This formula worked for me.
Sep 16 2021 06:42 AM
@Lorenzo Kim thanks, thats very helpful.
How about if instead of excluding I want to only include field.
So base on the example I will be only including the "In flight Relief" in my sum calculation.
Maria
Sep 22 2018 12:22 AM
Solution