SUMPRODUCT and other formulas combined...
Have you tried it? The best way to learn is by trying. In essence, it should
work, but there are some gotchas to be wary of it. Try it and see if you get
any.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"cdavidson" wrote in message
...
I often use the SUMPRODUCT formula in the following manner:
=SUMPRODUCT(--(OFFICE=$B12),--(REVENUE<""),--(REGION="1 - Canada"))
where... OFFICE, REVENUE and REGION are all 'Names' given to column
ranges
I often, however, find that my data is structured in such a way that I
could
really benefit from being able to use other formulas in conjunction with
the
SUMPRODUCT format. For instance, it would be great if I could structure
the
'REGION' section of the above formula to only have to look at the first
character (I'll attempt to demonstrate my thinking by way of the
following
altered version of the above formula):
=SUMPRODUCT(--(OFFICE=$B12),--(REVENUE<""),--((LEFT(REGION,1))=1))
Is something like this possible?
Thanks in advance!
|