Can a formula be used in the Criteria field of SUMIF??
|
Yes, you can do =SUMIF(B3:B20,IF(H110,5,6))
-- HTH RP (remove nothere from the email address if mailing direct) "peter" wrote in message ... |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com