Forum Discussion
Adding up numbers that have blank celssmatching criteria in 1 or 2 ranges across 3 tables
Hi All I am trying to add up costs not captured using other formulas in an estimating tool. I have 3 tables (Resources, Non-resources, and Other Costs - I put them in separate tables to be dynam...
Fiona_Murphy Perhaps the easiest way would be to calculate the grand total and deduct the the sum of the expenses that are categorized. So in F10 it would be something like:
= SUM(K14:K1000)-F2-F6
But even better when you use structured tables to avoid direct referencing to a range like K14:K1000, or whatever is needed to capture all expenses.