Hi,
I'm new to this forum and have an issue with a SUMPRODUCT formula with a COUNTIF clustered within. Basically I'm trying to search one column for a specific value and return how many lines fall within a range from a second column. Specifically I'm trying to find in G:G all values of R01 that in E:E fall within the range of 183 - 365 (6 - 12 months) for a seperate Stats sheet. I have used a select range rather than whole columns as this was giving me issues, this is what I have so far:
=SUMPRODUCT(('Current Trainees'!G8:G500="R01")*(COUNTIF('Current Trainees'!E8:E500,">=184")-(COUNTIF('Current Trainees'!E8:E500,"<=365"))))
I am finally getting a value returned to me rather than an error however the value is incorrect.
Thanks in advance
I'm new to this forum and have an issue with a SUMPRODUCT formula with a COUNTIF clustered within. Basically I'm trying to search one column for a specific value and return how many lines fall within a range from a second column. Specifically I'm trying to find in G:G all values of R01 that in E:E fall within the range of 183 - 365 (6 - 12 months) for a seperate Stats sheet. I have used a select range rather than whole columns as this was giving me issues, this is what I have so far:
=SUMPRODUCT(('Current Trainees'!G8:G500="R01")*(COUNTIF('Current Trainees'!E8:E500,">=184")-(COUNTIF('Current Trainees'!E8:E500,"<=365"))))
I am finally getting a value returned to me rather than an error however the value is incorrect.
Thanks in advance