Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 11,058
I'm a leaner wiht a headache!!

The formula depends on the structure of your table. Here is a very simple
example using Cells A1 thru D15:

Monday car \$1.00 559
Monday truck \$5.00 326
Monday pogo \$0.50 266
Tuesday car \$1.00 491
Tuesday truck \$5.00 200
Tuesday pogo \$0.50 494
Wednes car \$1.00 378
Wednes truck \$5.00 280
Wednes pogo \$0.50 577
Thursday car \$1.00 515
Thursday truck \$5.00 435
Thursday pogo \$0.50 404
Friday car \$1.00 196
Friday truck \$5.00 154
Friday pogo \$0.50 379

This flexible structure allows different tolls on different days. For the
Monday total:

=SUMPRODUCT((A1:A15="Monday")*(C1:C15)*(D1:D15)) will display 2322

Similar for the other days.
--
Gary''s Student - gsnu200903

"Thicky Vicky!!! :O(" wrote:

Ok,i have a spreadsheet with toll bridge charges for mon - fri and costs on
cars,trucks & motor bikes, plus the number of vehicles been through the toll
each day......i have to calculate with one formula the daily amount taken in
money...starting with monday then being able to drag this down through every
day to fri.............................My brain has imploded!!!......i've
been sat here for hours trying to do the formula and just can't get it
of wood,and i know it is really simple!!! :O(

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post klafert Excel Worksheet Functions 9 September 10th 06 07:47 PM maggie Charts and Charting in Excel 2 May 22nd 06 06:37 PM Chip Smith Excel Discussion (Misc queries) 1 March 31st 06 07:11 PM Rothman Excel Worksheet Functions 6 March 9th 06 10:25 PM Rafael Excel Discussion (Misc queries) 7 December 22nd 04 05:53 AM

All times are GMT +1. The time now is 05:56 AM.