Which formula do I need?

  • Thread starter Thread starter Davey Boy
  • Start date Start date
D

Davey Boy

Hi!

Would appreciate any help you can send my way:

I have a sales spreadsheet showing sales per month for last year versus
the current year. The data is input for all of last year and the data
for the current year would be available through the current month.

There are totals at the end of each row and I'd like the total for the
prior year to add through the current month.

Example:

First Row: JAN thru DEC sales
Second Row: JAN thru AUG sales

The total column for the first row would only add the sales from JAN -
AUG.

I tried using SUMIF but don't think I'm doing it right and I don't think
having 12 nested IFs is the way to go...

TIA!!!

dave
 
Hi Davey Boy

assuming your last year values are in row 2 and the current year values are
in row 3 this formula should work for you
=SUMIF(B3:M3,"<>"&"",B2:M2)

Cheers
JulieD
 
Back
Top