Calculating the monthly total

[Christine Wilso]

I have a spreadsheet downloaded from a database which retrieves th
number of sales for different regions every month, the months that hav
not occured have #N/A in the cell:
(A)Region (B)Month-No (C)Month (D)Sales
Glasgow 01 April 1500
Glasgow 02 May 1310
Glasgow 03 June #N/A
" " " "
Glasgow 12 March #N/A

Another worksheet within this workbook calculates the year to dat
total sales and the monthly sales. I know how to calculate YTD bu
can't pick out the current months sales each time I refresh th
download. For example in May, it should state 1310, in April 1500. Doe
anyone know how to do this

 

[BenjieLop]

See if this works for you ...

=sumif(C$1:C$100,"April",D$1$100)

where

C$1:C$100 -- column where your months are entered
D$1$100 -- sales figures are entered

or, more generally,

=sumif(C$1:C$100,Your_Chosen_Month_Here,D$1$100)

 

[mzehr]

Hi Christine,
One way would be to use a pivot table to summarize your
data. Check out the following websites for starters:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.contextures.com/xlPivot01.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


Also you could use =SUMPRODUCT(--(c2:c10="April")*
(D210="Glassgow")*(D210)). This is helpful if there
are multiple locations and entries for each location.