SUMIFS function

Question

SUMIFS function

[Closed]

Report

Dominic - Sep 7, 2015 at 07:28 AM
TrowaD

Posts: 2779
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 29, 2021

- Sep 8, 2015 at 11:31 AM

Hello,

I am trying to sort the formula below

=SUMIFS(Sheet3!$AI$15:$AY$22,Sheet3!$B$15:$B$22,$A142,Sheet3!$AI$4:$AY$4,D$2)

the criteria_range1, criteria1 have false evaluation as do [criteria_range2, criteria2]

the formula returns #VALUE!

Any advice you would be very welcome, many thanks Dominic

<config>Windows 7

SUMIFS function
Excel - Using SUMIF function with two criteria - How-To - Excel
Functions of spreadsheet - Articles
Functionality of wifi - How-To - Connection
What is mutator function in c++ - How-To - C++ Language
Acer function keys not working - How-To - Office Software

1 reply

Ask a question

TrowaD · Answer 1 · 2015-09-08T11:31:10-0400

Hi Dominic,

On the formula window where you input the criteria, you will find a help link in the bottom left.

Clicking on that will learn you that all criteria ranges should be the same size and that the criteria should be a single value.

You have use different range sizes and where the criteria should be you used a range as well.

The function help also shows some examples of how to use the formula correctly.

Good luck and best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

SUMIFS function

1 reply

Your reply

Subscribe To Our Newsletter!