Hi all,
i have a sheet in which the milk qty is given with their corresponding Fat% and SNF % like this
Qty Fat% SNF%
1200 5.16 8.56
1300 6.20 9.27
1500 7.20 9.34
I have two things to ask
One is i want to create a query which will return sum of Qty of milk based on the buckets where Fat% is between 4-5; 5-6 and 6-7
second is i want to create a query which will return sum of Qty of milk based on the buckets where Fat% is between 4-5 and SNF % is between 8-9; where Fat% is between 5-6 and SNF % is between 8-9
Please help me out