Hi
Can anyone see a problem with this formula please?
=SUMIFS(Totalcost,VBA_code,B1,Receipt_date,">=Period!$C$10")
The formula is acting on a table with one transaction per row for multiple businesses identified by VB_code. Each transaction has a Receipt Date in a column called "Receipt_date".
I'm trying to sum the total costs to date of each business (VBA_code) from the date held in Period!$C$10. Cell B1 has the business code I'm interested in.
The formula always returns zero.
If I omit Receipt_date,">=Period!$C$10" the formula returns the total costs irrespective of the Receipt_date. So I guess there is something wrong with the syntax of Receipt_date,">=Period!$C$10" but I can't see what it is.
Help!
Simon
Bookmarks