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]

Thank you Robert

 

[GWB]

what version of excel are you using?

2003....

 

[Robert Mika]

Thank you Robert

You are welcome.
The first solution should work

 

[T. Valko]

2003....

Here's one way...

Use cells to hold the criteria:

A1 = Day
B1 = DF098CDW

=SUMPRODUCT(--(R3:R1000=A1),--(V3:V1000=B1),Q3:Q1000)

Note that with SUMPRODUCT you *can't* use entire columns as range references unless you're using Excel 2007 or later.