Dark0Prince
Active Member
- Joined
- Feb 17, 2016
- Messages
- 433
=SUMPRODUCT(--(JOET!$H$1:$H$4999>=42339),--(JOET!$H$1:$H$4999<=42369),--(JOET!$A$1:$A$4999=8568),IF(1/COUNTIF(JOET!G:G,"<=1000")=1,1,0)))
So I'm attempting to COUNTIFS a sum range if other statements are true. The problem I think is the end of my statement COUNTIF(JOET!G:G,"<=1000")=1,1,0)))
I only want to count if there is an amount <=1000. Did I write that wrong?
So I'm attempting to COUNTIFS a sum range if other statements are true. The problem I think is the end of my statement COUNTIF(JOET!G:G,"<=1000")=1,1,0)))
I only want to count if there is an amount <=1000. Did I write that wrong?
Last edited: