Using "IF" to do a SUM

R

RWN

In a report I need to add the quantity to a =SUM( only if the Bonus (a
logical -True or False field) is False. Something like this - If ([Bonus] =
False, =Sum([QuantitySum]). Does any one know the correct syntax??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Making a macro only work on certain files 2
How do I create a set of words that are flagged? 0
VBA word change keys 0
Need help modifying code 0
SQL Syntax in macro with & " 4
VBA to look for more than 1 key word and highlights 8
Formula Help 0

Top