Thread
:
In the sumif command, is there a way to set the criteria to =d10?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
In the sumif command, is there a way to set the criteria to =d10?
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett
In the sumif command, is there a way to set the criteria to =d10?