LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default What is the Difference Between <30 and .<30

Actually I am using Sumif function

In A2:A5 in sheet 1 is Date

Like
<30
<60
30
60


In Sheet2 in A2:A300
30

<60
<30
<60 and so on

Sheet2 B2:B300

100
200
300
500
600
800 and so on

Now When I use =sumif(Sheet2!A:A,Sheet1!A2,Sheet2!B:B)

And it shows 0 in all Cells

But one of My friend Suggest me to Put dot or Comma Before Data in A:A in
Sheet 1 and Sheet2

Like .<30 or ,<60 and so on

It works perfectly.

But unfortunately my Friend dont know the why it happened

Could you please suggest me why it happened?

Thanks in Advance

Hardeep kanwar


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum difference Kaye Excel Discussion (Misc queries) 3 October 10th 08 10:11 PM
subtract the time difference from another time difference Dannigirl Excel Discussion (Misc queries) 3 September 30th 07 03:47 PM
Difference Stevep-4 Excel Discussion (Misc queries) 11 October 4th 06 11:52 AM
Difference Sarah Talley Excel Worksheet Functions 6 October 17th 05 11:39 PM
charting a difference of 2 columns' w/o adding a difference column Wab Charts and Charting in Excel 4 July 27th 05 02:37 AM


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"