Sumif

GWB

Board Regular
Joined
Apr 23, 2010
Messages
89
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.
 
Upvote 0
=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)
 
Upvote 0
I fixed the range specified but still don't get a result.

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

Still getting an error
 
Upvote 0
I'm still not getting it

Using this:
SUMIF(Q3:Q3000,V:V="DF098CDW",SUM_RANGE) I get a #name error.
 
Upvote 0
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?
 
Upvote 0
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)
 
Upvote 0
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?
 
Upvote 0
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")
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top