A formulq to give running total

[pedro-egoli]

Have a spreadsheet with individual columns for 12 months.
Can't seem to get a formula to do the following
. Provide a running total of certain cells each month, only when there is data in 2 cells, otherwise blank
.When there is data in these 2 cells (various columns) I want previous total to be added to current months total
. As i will be dragging formula across the various columns I want future columns to be blank
The formula I am trying is

=IF(and(F3>1,F52>1,E54+SUM(F52+F53),"")

F3 and F52 are numbers .
E54 is the total of E52 + E53

The above formula in cell F54 gives an error message " your formula is missing a parenthesis..."

Any assistance appreciated.

Pedro

 

[Aladin Akyurek]

Perhaps...

=IF(COUNT(F3,F52),SUM(E54,F52:F53),"")

is what you probably intend...

 

[pedro-egoli]

Thanks Aladin.
Nearly there

Excel Workbook
	E	F	G
51	to 16/2/11	*	to 20/5/11
52	$52.00	*	$344.09
53	*	*	$307.89
54	$52.00	$52.00	$703.98
SUMMARY PV PRODUCTION USAGE (2)

If formula can be tweaked to show a blank in cell F54 , and future cells where there is no data in rows 52 and 53, that would be perfect.

Thanks
Pedro

 

[Aladin Akyurek]

Thanks Aladin.
Nearly there

Excel Workbook
	E	F	G
51	to 16/2/11	*	to 20/5/11
52	$52.00	*	$344.09
53	*	*	$307.89
54	$52.00	$52.00	$703.98
SUMMARY PV PRODUCTION USAGE (2)

If formula can be tweaked to show a blank in cell F54 , and future cells where there is no data in rows 52 and 53, that would be perfect.

Thanks
Pedro

=IF(COUNT(F3,F52),SUM(E54,F52:F53),"")

attemps to sum when the COUNT bit evaluates to a value >= 1. If the count is 0, we get a blank. If you want the count to be 2 for summing to happen, try...

=IF(COUNT(F3,F52)=2,SUM(E54,F52:F53),"")

 

[pedro-egoli]

That created a blank as I wanted but not a progressive total to include the previous figure in cell E54

Excel Workbook
	E	F	G
51	to 16/2/11	*	to 20/5/11
52	$52.00	*	$344.09
53	*	*	$307.89
54	$52.00	*	$651.98
SUMMARY PV PRODUCTION USAGE (2)

Need G54 to be $703.97 please

Pedro

 

[pedro-egoli]

Figures will be put in each 3 months so this small amendment to Aladin's formula might do the trick

=IF(COUNT(G3,G52)=2,SUM(E54:F54,G52:G53),"")

May come back in a couple of months but am hopeful this has done what I want
Thanks again Aladin

Pedro