Quote:
Originally Posted by p45cal
Look in cells G7:H15 in the Copia de Material order sheet in the attached.
Formulae like:
=SUMIF($E$8:$E$28,G7,$C$8:$C$28)
|
Dear P45cal,
Can we have it so that instead of looking for a specific value, in this case G7, it looks within a range of values?
I have 36 colours from which to look for, and if I use the formula as you specified it, I would need 36 rows, one for each colour, which would be messy.
I would need the formula to first group all the colours that appear above (as in column G), and then do the sum.
Can you give me a hand with that?
Thanks a lot!!!