Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - SUMIF
Resolved · Low Priority · Version Standard
Kenneth has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Can you use SUMIF function with multiple criteria, eg:
Sum column D, if A=Yes, B=Yes and C=No.
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
|
Excel tip:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
We'll call during UK business hours
Server loaded in 0.08 secs.