I am trying to utilize a SUMIF function that references a cell to provide the
the criteria, so that I can changed the criteria inside a optimization or
scenario. My functions are all returning zero when I use the cell reference,
but when I use the actual value, it returns what it should? Any way I can
get around this?

It should work properly if you are looking for an equal condition.
However, if you are looking for ,<,or <, then you need something like

=SUMIF(CritRange,""&A1,SumRange)

where your criterion value is in A1, if you are looking for an
inequality. You put whatever inequality sign you need between the
quotes.

HTH

DOR

Thanks! Works great. I was suspecting syntax but as usual, the help files
didn't help

"DOR" wrote:

It should work properly if you are looking for an equal condition.
However, if you are looking for ,<,or <, then you need something like

=SUMIF(CritRange,""&A1,SumRange)

where your criterion value is in A1, if you are looking for an
inequality. You put whatever inequality sign you need between the
quotes.

HTH

DOR

On Sun, 13 Nov 2005 13:50:06 -0800, "Albie"
wrote:

I am trying to utilize a SUMIF function that references a cell to provide the
the criteria, so that I can changed the criteria inside a optimization or
scenario. My functions are all returning zero when I use the cell reference,
but when I use the actual value, it returns what it should? Any way I can
get around this?

It's just a syntax issue:

=SUMIF(rng_to_check, "=" & cell_ref, rng_to_sum)




--ron

Thanks! Works wonders!

"Ron Rosenfeld" wrote:

On Sun, 13 Nov 2005 13:50:06 -0800, "Albie"
wrote:

I am trying to utilize a SUMIF function that references a cell to provide the
the criteria, so that I can changed the criteria inside a optimization or
scenario. My functions are all returning zero when I use the cell reference,
but when I use the actual value, it returns what it should? Any way I can
get around this?

It's just a syntax issue:

=SUMIF(rng_to_check, "=" & cell_ref, rng_to_sum)




--ron

I am trying to use a countif formula to count column a - rows 6-99 if
between10%and 25% AND if column b =DS.

can you help - i have tried the sumproduct - might not have the right
formula to put in but I tried and i have tried the function and several other
suggestions the help provided.

I would greatly appreciate it. Thanks

Try this:

=SUMPRODUCT(--(A6:A99=10%),--(A6:A99<=25%),--(B6:B99="DS"))

--
Biff
Microsoft Excel MVP


"Laura" wrote in message
...
I am trying to use a countif formula to count column a - rows 6-99 if
between10%and 25% AND if column b =DS.

can you help - i have tried the sumproduct - might not have the right
formula to put in but I tried and i have tried the function and several
other
suggestions the help provided.

I would greatly appreciate it. Thanks

it works!!! Thank you so very much.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A6:A99=10%),--(A6:A99<=25%),--(B6:B99="DS"))

--
Biff
Microsoft Excel MVP


"Laura" wrote in message
...
I am trying to use a countif formula to count column a - rows 6-99 if
between10%and 25% AND if column b =DS.

can you help - i have tried the sumproduct - might not have the right
formula to put in but I tried and i have tried the function and several
other
suggestions the help provided.

I would greatly appreciate it. Thanks

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Laura" wrote in message
...
it works!!! Thank you so very much.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A6:A99=10%),--(A6:A99<=25%),--(B6:B99="DS"))

--
Biff
Microsoft Excel MVP


"Laura" wrote in message
...
I am trying to use a countif formula to count column a - rows 6-99 if
between10%and 25% AND if column b =DS.

can you help - i have tried the sumproduct - might not have the right
formula to put in but I tried and i have tried the function and several
other
suggestions the help provided.

I would greatly appreciate it. Thanks

Hi Im having a similar issue, I'm trying to count numbers within a range and
then substract that number to another countif formula so something like this:

=COUNTIF('Data Report'!$N$14:$N$2857,"O-PFS"-(COUNTIF('Data
Report'!$O$14:$O$2857,"75<85")))

so N coulmn has codes like"o-pfs" and O columns has numbers, in a separate
sheet I need to count the number of N with "o-pfs" minus O column within 75
and 85..
does this make sense? my formula gives me 0 in return???
thanks

=COUNTIF('Data Report'!$N$14:$N$2857,"O-PFS"-
(COUNTIF('Data Report'!$O$14:$O$2857,"75")-COUNTIF('Data
Report'!$O$14:$O$2857,"=85"))

--

HTH

Bob

"ginger82" wrote in message
...

Hi Im having a similar issue, I'm trying to count numbers within a range
and
then substract that number to another countif formula so something like
this:

=COUNTIF('Data Report'!$N$14:$N$2857,"O-PFS"-(COUNTIF('Data
Report'!$O$14:$O$2857,"75<85")))

so N coulmn has codes like"o-pfs" and O columns has numbers, in a separate
sheet I need to count the number of N with "o-pfs" minus O column within
75
and 85..
does this make sense? my formula gives me 0 in return???
thanks