SUMIF Formula question

Colin Legg · #3 05-22-2011, 02:17 AM

Hi,

Quote:

I want to use the second variable in the SUMIF formula to refer to the contents of a cell rather thyan a string.

Suppose your condition is ">100", so if it was in the formula it would look like this:

Code:

=SUMIF(C15:C45,">100",F15:F45)

You could then put 100 in T10 and reference it like this:

Code:

=SUMIF(C15:C45,">"&T10,F15:F45)

In my experience, that's what most people do.

If you want the > operator in cell T10 too, then you would put this in T10:

Code:

=">100"

And then your formula would be

Code:

=SUMIF(C15:C45,T10,F15:F45)

If you want to see more examples, here's a tutorial I wrote on SUMIF.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help With SUMIF Formula In R1C1 Style	Todd	Excel	9	02-27-2010 08:30 PM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM
Need help with a formula	tinkertron	Excel	11	04-16-2009 11:43 PM
Categories question & replying with attachment question	glitzymama	Outlook	0	03-15-2006 09:32 AM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM