sitelbanat
Board Regular
- Joined
- Oct 17, 2005
- Messages
- 152
This works great
=COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82))
But I need to add a IF function at the end of the formela. I was wondering would I use AND IF or just IF?
I want the IF function to look at the selected cells from E69:E82 and if the total value is <0 than +1 to total count of O69:O82.
Please Help
=COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82))
But I need to add a IF function at the end of the formela. I was wondering would I use AND IF or just IF?
I want the IF function to look at the selected cells from E69:E82 and if the total value is <0 than +1 to total count of O69:O82.
Please Help