Sumif

[GWB]

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

 

[GWB]

I realize now that the range I specified is bogus so that is one error.

 

[Robert Mika]

=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)

 

[GWB]

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

 

[GWB]

=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

 

[GWB]

I'm still not getting it

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

 

[Robert Mika]

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?

 

[GWB]

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)

 

[T. Valko]

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?

 

[Robert Mika]

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")