I pull a list of vars out a database, and i need to calculate the price with different amounts of tax. Problem is that calc won’t calc from referenced cells.
I want to sum all price that have 6% sale tax: =sumif(B2:B6;A7;A2:A6)
Works! But not when using cells from database (reference).
If I manually put in the data, it does calc, any pointers?