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: 106
Default SUM Product formula help needed

I have a SUMIF formula

SUMIF(U3:U3000,"<cleared",Q3:Q3000)

that sums a value stored in column Q items that do not have a status of
cleared (status is located in column U)

I want to add a second criteria to only sumif the above is true and i have
column L that has the number of days the invoice is past due - i only want to
include in the subtotal items that are 30 days or greater

Is this a sum product function and how would i write that?


 
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
Sum product the right formula? Louisville Cardinals Excel Discussion (Misc queries) 4 January 4th 06 04:44 PM
How do add text after the product within a formula? traybuddy Excel Discussion (Misc queries) 4 October 13th 05 06:06 PM
Product formula help Elbowhite Excel Worksheet Functions 2 August 23rd 05 11:55 PM
Sum product help needed with an extra variable please and thankyou Anthony Excel Worksheet Functions 6 July 12th 05 04:31 PM
Sum Product Help Needed Edgar Thoemmes Excel Worksheet Functions 1 January 4th 05 04:57 PM


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