LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mbparks
 
Posts: n/a
Default Sumproduct formula

I am working on a spreadsheet that tracks when items are requested and
received.
Sheet 1 is the log.
Sheet 2 is a formula sheet. (This is where I need another formula.)
I have 12 sheets- individual monthly reportsfor the year.
Can someone please help me with a formula that will count the number of
items outstanding and calculate the age of the outstanding items as of the
last day of the month for the reports.
 
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
sumproduct formula to slow Todd Excel Worksheet Functions 4 December 21st 04 11:25 PM
SUMPRODUCT formula shmurphing Excel Worksheet Functions 4 December 21st 04 10:43 PM
sumproduct formula Brian Excel Worksheet Functions 1 December 12th 04 05:21 AM
Shorten sumproduct formula Andre Croteau Excel Discussion (Misc queries) 1 December 11th 04 10:30 PM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


All times are GMT +1. The time now is 12:27 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"