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

sumifs criteria

ResolvedVersion 2007

Mark has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel PowerPivot course
Excel Dashboards for Business Intelligence course

=SUMIFS Criteria

Hi,

I'm using the following =SUMIFS formula, =SUMIFS(O:O,K:K,D15,L:L,">=4"), the ">=4", is one of my criteria, but I would like to change this so it references a cell e.g. F10. I know that if I were to change ">=4" to ">=F10" it would then read the F10 as text and would then error out.

How can I get around this?

Thanks,
Mark

RE: =SUMIFS Criteria

Hi Mark

Thanks for getting in touch. You have to concatenate your criteria with an ampersand character. It'll look like this:

=SUMIFS(O:O,K:K,D15,L:L,">="&F10)

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.