Conditional SUM based on number of rows

[piannetta]

Hi,

I have 2 columns, Column A with numbers in all 20 rows (forecast) and Column B with numbers populated as time progresses (actual).

In the total of Column A, I only want to SUM the number of rows that are populated in Column B, so I can get a proper Month To Date comparison.

So for example, I'm 2 days into the 20 day period, I only want the sum of Column A for those same 2 days.

I've tried to figure it out but can't seem to find a way. Hoping someone can help me please.

Cheers,
Pete

 

[JoeMo]

If the forecast data are in A2:A12 and the Actuals data in B2:B21 try:

=SUMIF($B$2:$B$21,">0",$A$2:$A$21)

 

[piannetta]

If the forecast data are in A2:A12 and the Actuals data in B2:B21 try:

=SUMIF($B$2:$B$21,">0",$A$2:$A$21)

OMG, of course!

Thank you!