Ian Bell
asked on
count values within multiple bands
Hi,
I'd like help to count number of values with increments of .02 and aslso to meet one other condition..
Please see spreadsheet for full explanation and example
Thanks
Ian
multiple-bands.xlsx
I'd like help to count number of values with increments of .02 and aslso to meet one other condition..
Please see spreadsheet for full explanation and example
Thanks
Ian
multiple-bands.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Ejgil,
Thanks for the response, there seems a problem as all cell contents I10:BE10 ARE ALL ZERO VALUES ?
example....... C12 = .94 and has FP=1
Thanks for the response, there seems a problem as all cell contents I10:BE10 ARE ALL ZERO VALUES ?
example....... C12 = .94 and has FP=1
I believe you want to count if Col B (FP) = 1 in second criteria.
Please see attached...
multiple-bands_v2.xlsx
Please see attached...
multiple-bands_v2.xlsx
ASKER
Hi Shums,
something still not right as cell C12 has value 0.94 and FP=1 but in total cell BB10 it shows 0
something still not right as cell C12 has value 0.94 and FP=1 but in total cell BB10 it shows 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys for the help. It worked perfectly
Cheers
Ian
Cheers
Ian
Please observe that the values in row 8 did not match exactly, due to rounding, so if have changed the formula.
multiple-bands.xlsx