Thread: Help please!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sierra Sierra is offline
external usenet poster
 
Posts: 6
Default Help please!

I've been working on a formula for adding expenses using multiple criteria
for about nine hours now, and I would realy appreciate some help! Here's my
situation:

Summary sheet:
A B C
1 222220 3330 (Total of data from other worksheet where row has A
and B)
2 222220 3333
3 222229 33353
4 222229 3330

Data sheet(different worksheet, same workbook)
Cannot have colomn headers/titles

A B C ............ L
1 222220 ..... 3333 ..... 596.35
2 222220 ..... 3330 ..... 254.98
3 222220 ..... 3330 ..... 1547.36
4 222229 ..... 3330 ..... 259.36
5 222229 ..... 33353 ..... 12.36

The data goes on for about 1500 lines, so I would really like to find a
formula that is something of a sumif, true/false, etc. that will give me the
results I need. I've came close, but all I get is zero...literally!

If anyone has any suggestions it would be greatly appreciated!

Thanks,
Sierra :)