CONDITIONAL SUM FOR ONLY VISIBLE CELLS
 

When =SUBTOTAL(9,_:_) is used it works great for reflecting totals of only
the filtered/visible cells. What sort of formula work if a conditional sum is
required. For example in the following case a simple =subtotal(9,B2:B10)
would show 2950 when Column A is filtered to reflect only Region "A". But how
to reflect totals of only those which belong to Dept I when Filteration as
per Column A is made.

For example:

Region Amt Dept
A 234 I
A 536 II
A 881 I
B 272 II
A 530 I
B 538 II
A 769 I
B 895 II
C 701 I

Subtotal results in 2950 if column A is filtered to reflect "A". But I also
want at the same time a result of the visible cells containing only "I" in
column C, i.e. 2414.


--

Best Regards,
FARAZ A. QURESHI

CONDITIONAL SUM FOR ONLY VISIBLE CELLS
 

Filtering also for Dept I in column C gives the required result (2414).
Doesn't it suit your needs?

Regards,
Stefi


€žFARAZ QURESHI€� ezt Ã*rta:

When =SUBTOTAL(9,_:_) is used it works great for reflecting totals of only
the filtered/visible cells. What sort of formula work if a conditional sum is
required. For example in the following case a simple =subtotal(9,B2:B10)
would show 2950 when Column A is filtered to reflect only Region "A". But how
to reflect totals of only those which belong to Dept I when Filteration as
per Column A is made.

For example:

Region Amt Dept
A 234 I
A 536 II
A 881 I
B 272 II
A 530 I
B 538 II
A 769 I
B 895 II
C 701 I

Subtotal results in 2950 if column A is filtered to reflect "A". But I also
want at the same time a result of the visible cells containing only "I" in
column C, i.e. 2414.


--

Best Regards,
FARAZ A. QURESHI