Fri 7 Dec 2007, 17:07Delegate Kenneth said...
Kenneth has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
SUMIF
Can you use SUMIF function with multiple criteria, eg:
Sum column D, if A=Yes, B=Yes and C=No.
Mon 10 Dec 2007, 15:47Trainer Carlos said...
RE: SUMIF
Kenneth
To do the above you need the Conditional Sum Wizard AddIn
Go to Tools/AddIns and make sure Conditional Sum Wizard is ticked.
Then follow the steps in the wizard selecting with range to add and which criteria to follow
Hope this helps
Carlos
