gaj104
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 864
Hi,
Why is it if I use a defined range my sumproduct formula works, but when I use an entire column the sumproduct fails. Is there a workaround to this?
Many thanks
Why is it if I use a defined range my sumproduct formula works, but when I use an entire column the sumproduct fails. Is there a workaround to this?
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | Apples | Red | 10 | Conditions | |||||
3 | Pears | Yellow | 20 | Fruit | Apples | ||||
4 | Apples | Green | 55 | Colour | Red | ||||
5 | |||||||||
6 | 85 | Total | 10 | ||||||
7 | |||||||||
8 | Total | #NUM! | <<< why doesnt this work? | ||||||
Sheet2 |
Many thanks