excel+courses - sumif

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - SUMIF

excel+courses - SUMIF

resolvedResolved · Low Priority · Version Standard

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.

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


 

Excel articles

Excel tip:

Selecting your working range

In 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.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

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

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.