Why isnt this working anymore! Argh.

[Angliojoe]

Hello All,

I have been using the following sum to calculate the amount of money spent between two dates.

=SUMIFS('data'!$AD$2:$AD$184,'data'!$Z$2:$Z$184,">="&A4,'data'!$Z$2:$Z$184,"<="&B4)

In coloumn A is the start of the week (date) and in coloumn B is the end of the week (date). I have it set up so that each row shows me the week spend and when I first set it up everything was rosy but I have just dumped aload of new data into the spreadsheet and adusted the ranges (to 184) and for some reason the first week works but nothing else does??

Any ideas or help please

Joe.

 

[PaddyD]

can't recall behaviour of sumifs() (and I'm on 2003 at the moment), but perhaps:

I have just dumped aload of new data into the spreadsheet

...provides a clue. check that the data's not being treated as text. what does =isnumber() return for some of the new data that's meant to be numeric? If it returns false, you may have your answer, and the quick fix is to copy a blank cell, select the 'numbers', then edit | paste special | add.