SUMIF on Cell Result

M

Mike

How can I build a sumif function that uses a value in a
cell as the criteria. I tried SUMIF(W3:AH3,"<=H3",W6:AH6)
where the H3 is a cell containing a value. If I just put
the value in the formula it works. If I use the reference
I get a 0. Any ideas?
 
P

Prashanth

if you are using a reference then you should not put " ".

try this instead
=SUMIF(W3:AH3,H3,W6:AH6)

<=(less than) does not work here. :( only specific values

Rgds,
Prashanth
 
P

Prashanth

well... <= works too :-D
if you are using a reference then you should not put " ".

try this instead
=SUMIF(W3:AH3,H3,W6:AH6)

<=(less than) does not work here. :( only specific values

Rgds,
Prashanth
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Function ? 1
Specifying comparision criteria with SUMIF() 2
SUMIF ERROR 3
SumIf across columns instead of rows 2
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
Sumif Function 2
sumif using "AND" and "Date" 2
SUMIF on a Calculated Field 3

Top