YTD Totals and Variances

C

Christine Wilso

Row 1:Area/ShopNo/Month/Sales2003-04/Sales2004-05
Row 2:Liverpool/31/April/156/150
Row 3:Liverpool/31/May/148/140
.......
Row 13:Liverpool/32/April/160/170
.......
Row 25:Liverpool/33/April/140/135
.......
Row 36:Liverpool/33/March/140/#N/A

If a month has not occured yet #N/A appears as the figures are take
from another database
 
A

Alex Delamain

If I understand correctly you want to sum the previous year column fo
every month where there is a value in the current year.

The following will sum sales for shop 31 for 2003-04 (column D) fo
each month where the 2004-05 total is not #N/A

=SUMPRODUCT((B2:B13=31)*(D2:D13)*(ISNA(E2:E13)=FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating YTD for 2004/05 & 2003/04 2
http://netscan.research.microsoft.com/Static/reportcard.asp?timespan=y&searchdate=6/13/2004&searchfo 2
LOOKUP function 3
Graphing problem - data with multiple series 1
[C# and WMI] : Programm run to slow 11
Vuescan tif can't be read 4
Problem with 'header' user control in copied asp.net project 1
Compiler Error Message: CS1595 1

Top