LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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 :)

 
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



All times are GMT +1. The time now is 07:29 AM.

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"