ExcelBanter - Sumif criteria greater than or less than another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumif criteria greater than or less than another cell (https://www.excelbanter.com/excel-discussion-misc-queries/252544-sumif-criteria-greater-than-less-than-another-cell.html)

Don O

Sumif criteria greater than or less than another cell

SUMIF(A1:A10,B5,C1:C10)

You can see what I'm trying to do. How do I do it?

Gary Keramidas

Sumif criteria greater than or less than another cell

maybe this is what you want

=SUMPRODUCT((A1:A10B5)*(C1:C10))

--

Gary Keramidas
Excel 2003

"Don O" <Don wrote in message
...
SUMIF(A1:A10,B5,C1:C10)

You can see what I'm trying to do. How do I do it?

Jacob Skaria

Sumif criteria greater than or less than another cell

Try

=SUMIF(A1:A10,"" & B5,C1:C10)

Since B5 is a cell reference you need to combine the text string "" with
the cell reference using &

--
Jacob

"Don O" wrote:

SUMIF(A1:A10,B5,C1:C10)

You can see what I'm trying to do. How do I do it?

Gary

Sumif criteria greater than or less than another cell

maybe this is what you want

=SUMPRODUCT((A1:A10B5)*(C1:C10))

"Don O" wrote:

SUMIF(A1:A10,B5,C1:C10)

You can see what I'm trying to do. How do I do it?

All times are GMT +1. The time now is 09:24 PM.