I would like to set the criteria to be equal to a value in a cell as opposed
to a specific number. Any idea?
I would like to set the criteria to be equal to a value in a cell as opposed
to a specific number. Any idea?
if you had just tried it first
=SUMIF(A3:A7,D1,B3:B7)
--
Don Guillett
SalesAid Software
[email protected]
"Nat" <[email protected]> wrote in message
news:[email protected]...
>I would like to set the criteria to be equal to a value in a cell as
>opposed
> to a specific number. Any idea?
or with qualifier
=SUMIF(B3:B7,">"&E1,C3:C7)
--
Don Guillett
SalesAid Software
[email protected]
"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> if you had just tried it first
> =SUMIF(A3:A7,D1,B3:B7)
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Nat" <[email protected]> wrote in message
> news:[email protected]...
>>I would like to set the criteria to be equal to a value in a cell as
>>opposed
>> to a specific number. Any idea?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks