Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 :) |