Thread
:
Kind-of extended sumif
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Kind-of extended sumif
OR for the or
=SUMPRODUCT(--(A1:A999=13)+(A1:A999=17)0),A1:A999)
this might also work
=SUMPRODUCT((A1:A999={13,17}0),A1:A999)
--
Don Guillett
SalesAid Software
"Frank Kabel" wrote in message
...
Hi
you can use SUMPRODUCT for this issue.
e.g. AND condition:
=SUMPRODUCT((A1:A999=13)*(A1:A999=17),A1:A999)
e.g. OR condition
=SUMPRODUCT(--(A1:A999=13)+(A1:A999=17)0),A1:A999)
HTH
Frank
BEDE wrote:
I'd like to have something like a sumif only that I wish to have some
complex conditions, like: "=13 or =17 or =22" instead of the simple
"=13", which requires me to have 3 sumifs, one for each of the 3
conditions that I wish to have or-ed. Is there anything ready-made?
Or is there some function that performs like "eval" in Foxpro (I know
that since Fox 2.0)?
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]