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: 1
Default sumif across multiple sheets in excel 2007 based on a condition

I have a small work book, tracks deliveries made and trucks used.
I have seven sheets Saturday thru Friday and one sheet that totals
everything up!

The weekly sheets have 34 rows representing 34 stores that we service and
the total sheet also has 34 rows that contain the totals for that week.

Here is my question I am trying to, on the totals sheet, sum up the total
trucks that we used per store per week. In the cell would be entered 0, 0.5,
1, 2 and so on depending on how many trucks we used for that day. Yes we use
0.5 if the store was combo'ed with another store. I need to have a count of
the cells that are greater than 0 or "0" I don't need a sum just need to
know that we used a truck so I would need a count on the cells that are
greater then 0... Countif works on just one sheet and I can't find a solution
to this... if someone with more experience to just direct me in the right
direction...
--
thanks for your help

Dave
 
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
Excel 2007: Can it SUMIF( ) using color as a condition ? Mr. Low[_2_] Excel Discussion (Misc queries) 7 April 2nd 23 07:44 PM
condition sumif commands based on date range? joek8724 Excel Discussion (Misc queries) 2 March 23rd 08 05:57 AM
Sum across sheets based on a condition GoBow777 Excel Worksheet Functions 3 March 8th 08 08:21 PM
Referencing Across Sheets Based On Condition Ramesh.S, India Excel Worksheet Functions 1 October 12th 06 02:48 PM
Is it possible to specify multiple condition with SUMIF? Daniel Excel Worksheet Functions 1 November 17th 04 01:38 AM


All times are GMT +1. The time now is 06:28 PM.

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"