ExcelBanter - In the sumif command, is there a way to set the criteria to =d10?

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

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

- - In the sumif command, is there a way to set the criteria to =d10? (https://www.excelbanter.com/excel-discussion-misc-queries/105114-re-sumif-command-there-way-set-criteria-%3Dd10.html)

Don Guillett

In the sumif command, is there a way to set the criteria to =d10?

or this way with qualifiers
=SUMIF(B3:B7,""&E1,C3:C7)

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message news:...
if you had just tried it first
=SUMIF(A3:A7,D1,B3:B7)

--
Don Guillett
SalesAid Software

"Nat" wrote in message
...
I would like to set the criteria to be equal to a value in a cell as
opposed
to a specific number. Any idea?

All times are GMT +1. The time now is 03:46 PM.