Subtotal positive and negative values on visible rows

[Cowichandave]

Not sure what works. Totals have to work with visible rows only as filters are actively changed
Column A must total only negative values in column C which would equal -121.15
Column D must total only positive values in column C which would equal 170.75
Colum C total contains column c combined total which equal 49.60

In other words Column A and D separate the values in Column C and total them separately.

Any help with a solution would be great. I tried using subtotal which works great with visible rows But I do not know how to separate the positive and negative values into totals

A	B	C	D	E
Total Negative		Total		Total Positive
-121.15		49.60		170.75
		44.50
		-24.45
		61.00
		65.25
		-64.50
		-32.20

 

[arthurbr]

In A2

=SUMIF(C2:C8,"<0")

In E2

=SUMIF(C2:C8,">0")

 

[Cowichandave]

Not sure what works. Totals have to work with visible rows only as filters are actively changed
Column A must total only negative values in column C which would equal -121.15
Column D must total only positive values in column C which would equal 170.75
Colum C total contains column c combined total which equal 49.60

In other words Column A and D separate the values in Column C and total them separately.

Any help with a solution would be great. I tried using subtotal which works great with visible rows But I do not know how to separate the positive and negative values into totals

A	B	C	D	E
Total Negative		Total		Total Positive
-121.15		49.60		170.75
		44.50
		-24.45
		61.00
		65.25
		-64.50
		-32.20

 

[Cowichandave]

That sums the entire column. Now if filters are turned on, I want it total the visible rows only like how subtotal works

 

[Peter_SSs]

One pretty easy way would be to use a helper column. I have used column G and whatever column it is could be hidden. Formulas are then pointed at that helper column.
I have included a simpler alternative for the negative sum in A2
Unfiltered it could look like this

24 11 06.xlsm
	A	B	C	D	E	F	G
1	Total Negative		Total		Total Positive
2	-121.15		49.6		170.75
3	-121.15		Header				Helper
4			44.5				44.5
5			-24.45				-24.45
6			61				61
7			65.25				65.25
8			-64.5				-64.5
9			-32.2				-32.2
Sum Filtered

Cell Formulas
Range	Formula
C2	C2	=SUM(G4:G9)
E2	E2	=SUMIF(G4:G9,">0")
A2	A2	=SUMIF(G4:G9,"<0")
A3	A3	=C2-E2
G4:G9	G4	=SUBTOTAL(103,C4)*C4

Now filter the original column C

24 11 06.xlsm
	A	B	C	D	E	F	G
1	Total Negative		Total		Total Positive
2	-32.2		73.3		105.5
3	-32.2		Header				Helper
4			44.5				44.5
6			61				61
9			-32.2				-32.2
Sum Filtered

Cell Formulas
Range	Formula
C2	C2	=SUM(G4:G9)
E2	E2	=SUMIF(G4:G9,">0")
A2	A2	=SUMIF(G4:G9,"<0")
A3	A3	=C2-E2
G4,G6,G9	G4	=SUBTOTAL(103,C4)*C4

 

[arthurbr]

That sums the entire column. Now if filters are turned on, I want it total the visible rows only like how subtotal works

That totals only positive or negative numbers contained in the column. BTW the total of positive numbers is 220.35 not 170..75...
Also

=AGGREGATE(9,5,C2:C8) is an option

 

[Peter_SSs]

BTW the total of positive numbers is 220.35 not 170..75...

@arthurbr
I think that you have missed that the bold row are all the required totals - given away by the first row headings and ..

Colum C total contains column c combined total which equal 49.60

.. so total of positives is 170.75