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.
Hi @Sergei Baklan
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.
maybe got around it although not in a sleek way.