Conditional summing more complex than my brain

[ArmstrongN]

All - thanks in advance

I have a sheet with a big table... each month of the year has three columns - an item count (not always used) a forecast column and an actuals column.
I need to test each month to see whether on a row there is a figure for actuals (in which case take that) and if not take the forecast

so:

A B C D E F
item Item count Jan Forecast Jan actuals Item count Feb Forecast Feb actuals....
Widget 3 121.34 142.36 2 323.00 *formula for total needed*
doobry 2 45.64 4 160.00 *formula for total needed*


For each row I need to determine whether there's a value in the actuals column (Jan-Dec) and take the actual if it exists and the forecast if not and sum all at the end of the row

I can do this a really long way using 12 nested if statements but is there a slicker way of doing this eg using arrays (which I don't fully understand)?

Many thanks

Simon

 

[ArmstrongN]

	A	B	C	D	E	F	... to Dec
item	item count	Jan Forecast	Jan Actuals	item count	Feb Forecast	Feb actuals	total needed
widget	3	121.34	142.26	2	323.00
doobry	2	45.64		4	160.00

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	item	item count	Jan Forecast	Jan Actuals	item count	Feb Forecast	Feb actuals	total needed
2	widget	3	121.34	142.26	2	323		465.26
3	doobry	2	45.64		4	160		205.64
Data

Cell Formulas
Range	Formula
H2:H3	H2	=SUMIFS(C2:F2,D2:G2,"",$C$1:$F$1,"*forecast")+SUMIFS(C2:G2,$C$1:$G$1,"*actuals")