SUMIF function
Actually I did get it to work now, thanks yak10 Wrote: None of these are working for me, I'm pretty sure that sumproduct is not what I want. This has to be a logical function. Sumproduct is not a logical function. I think Ashish is on the right track but it keeps coming back as either 0 (when it should be 200 from my original post) or #VALUE error. I need the sum of a column if 2 conditions are fulfilled. -- yak10 |
All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com