# Sumif

#### GWB

##### Board Regular
I'm trying to add numbers in a column if certain criteria are met.

So far I have tried SUMIF(R3:R10000=AB3,V3:V10000=AC3,Q3:Q10000)

So what I'm assuming (probably incorrectly) is that this will add the numbers in column Q *if* the text in column R = the text in cell AB3 *and* the text in coulumn V = the text in cell AC3

It does not return a result ...and actually throws an error message but does not say what the error is

Thanks for any help

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I realize now that the range I specified is bogus so that is one error.

=SUM(IF(R3:R10000=AB3,IF(V3:V10000=AC3,Q3:Q10000)))

Array formula confirm Control +Shift +Enter

In Excel 07/10
=SUMIFS(Q3:Q10000,R3:R10000,AB3,V3:V10000,AC3)

I fixed the range specified but still don't get a result.

What I have now:
SUMIF(Q3:Q10000,V3V10000=AC3 AND R3:R10000=AB3),sum_range)

Still getting an error

=SUM(IF(R3:R10000=AB3,IF(V3:V10000=AC3,Q3:Q10000)))

Array formula confirm Control +Shift +Enter

In Excel 07/10
=SUMIFS(Q3:Q10000,R3:R10000,AB3,V3:V10000,AC3)

Thank you

I'm still not getting it

Using this:
SUMIF(Q3:Q3000,V:V="DF098CDW",SUM_RANGE) I get a #name error.

SUMIF is taking only two ranges (criteria range, criteria , sum range)

You need to use SUMIFS IEXcel 07/10 only) or SUM(IF(....

What are you trying to achive with your last formula?

Trying to add the records in column Q (these are numbers) that correspond to the following text in column V "DF098CDW" and the following text in column R "DAY"

SUMIF(Q3:Q3000,(V:V="DF098CDW" AND "R:R="DAY"),SUM_RANGE)

Trying to add the records in column Q (these are numbers) that correspond to the following text in column V "DF098CDW" and the following text in column R "DAY"

SUMIF(Q3:Q3000,(V:V="DF098CDW" AND "R:R="DAY"),SUM_RANGE)
What version of Excel are you using?

Trying to add the records in column Q (these are numbers) that correspond to the following text in column V "DF098CDW" and the following text in column R "DAY"

SUMIF(Q3:Q3000,(V:V="DF098CDW" AND "R:R="DAY"),SUM_RANGE)

Excel 03/07/10

=SUM(IF(R3:R10000="DAY",IF(V3:V10000="DF098CDW",Q3:Q3000)))

Array formula confirm Control +Shift +Enter

In Excel 07/10
=SUMIFS(Q3:Q10000,R3:R10000,"DAY",V3:V10000,"DF098CDW")

Replies
2
Views
204
Replies
4
Views
335
Replies
8
Views
586
Replies
4
Views
385
Replies
17
Views
601

1,211,678
Messages
6,103,239
Members
447,848
Latest member
holale

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back