In the sumif command, is there a way to set the criteria to =d10?
I would like to set the criteria to be equal to a value in a cell as opposed
to a specific number. Any idea? |
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? |
All times are GMT +1. The time now is 06:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com