Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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
right!!!!................please help as i feel i am just as thick as a plank
of wood,and i know it is really simple!!! :O(

Reply
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
Need help wiht a macro for autofill rows klafert Excel Worksheet Functions 9 September 10th 06 07:47 PM
what's wrong wiht my bar graph in excel? maggie Charts and Charting in Excel 2 May 22nd 06 06:37 PM
sum wiht an if or vlookup? Chip Smith Excel Discussion (Misc queries) 1 March 31st 06 07:11 PM
Frequency Headache Rothman Excel Worksheet Functions 6 March 9th 06 10:25 PM
How to add cells wiht the condition of the former cell. Rafael Excel Discussion (Misc queries) 7 December 22nd 04 05:53 AM


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

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

About Us

"It's about Microsoft Excel"