Hello, I have a worksheet showing the values of pricing I have given to customers who will potentially order a product of mine. Naturally I have a cell showing the total of all quotes.
The problem is, some people ask me for quotes which are only for budgetary purposes. In other words, they need to know the current pricing, but will not be ordering. I want to keep them on my sheet, but I do not want the value to be added to the overall quote total, because I know they will not be purchasing. Here is what my sheet looks like:
SampleBudg.xlsx
I would like for the SUM formula in B9 to ignore any prices in column C that have "Budgetary" listed beside them in column D.
In this example, I would like the SUM formula in B9 to ignore the $60.00 in C7 because the value in D7 is Budgetary.
Can you help?
Thank you in advance.
Bookmarks