B
Belinda7237
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?
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?