Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum product the right formula? | Excel Discussion (Misc queries) | |||
How do add text after the product within a formula? | Excel Discussion (Misc queries) | |||
Product formula help | Excel Worksheet Functions | |||
Sum product help needed with an extra variable please and thankyou | Excel Worksheet Functions | |||
Sum Product Help Needed | Excel Worksheet Functions |