SUMIFS ? for multiple ranges
On Thursday, April 9, 2015 at 10:34:54 PM UTC-7, Claus Busch wrote:
Hi Howard,
Am Thu, 9 Apr 2015 18:14:36 -0700 (PDT) schrieb L. Howard:
Table 1 Table 2
A 4 X 7
B 3 Y 6
C 8 Z 3
Table 3 Table 4
B 1 C 8
C 2 X 7
D 5 Y 9
do it with multiple ranges:
=SUMIF(A:A,"C",B:B)+SUMIF(D:D,"C",E:E)
Regards
Claus B.
Okay, just thought there might be an "inclusive" kind of formula.
This will do, and if there were too many of these ranges I suppose one could resort to code.
Thanks Claus.
Howard
|