Nov 14 2019 04:21 AM
Hi
I am trying to sumif when the criteria and range are in multiple columns. Is this possible please?
So I need to know if Anytown's money has been awarded to a project in another location.
Nov 14 2019 04:31 AM
Nov 14 2019 05:07 AM
Thank you for that. It does seem to have worked, unfortunately. I think it is the sum range I need to work out. I need it to be able to add up column F and I based on D and G.
Nov 14 2019 05:12 AM
maybe got around it although not in a sleek way.
=(SUMIF(D:D,"Anytown",F:F))+(SUMIF(G:G,"anytown",I:I))