Hi Guys
Firstly all the data in the attached excel file is fictitious. I mention this as some contentious
Excel forums colleagues were concerned that I was baring my lot and suggested I make this point clear. Thank you and I will in future.
I have a sumif which refers to columns in another sheet and returns totals within a date range (VAT). My problem is when I alter that to take in two columns I get a #Values return. The columns I ma trying to get the data from are fine. I created a simple sum in the adjacent column and got the answer. Of course Excel can do what I want but not in the way I am asking her to.
Below the two functions
Please Login or Register to view this content.
The tab/sheet I am using is VAT I have highlighted the cells. you may see from the above where I am going wrong. I will be copying it to the others and then incorporating the answer into a macro.Please Login or Register to view this content.
Mark
Bookmarks