subtotal worksheet based on criteria
 

i have a master dataset that has a column called status in Column T. In
Column N I have an invoice amount.
If the status is "cleared" then I do not want the subtotal to include the
invoice amount, thus if there is no value (blank) in column T then I want the
equivilent column N invoice amount to be included in the subtotal.

How can i accomplish this without using a filter?

subtotal worksheet based on criteria
 

if data is in n2:n13 and t2:t13

=SUMIF(T2:T13,"<cleared",N2:N13)

--


Gary


"Belinda7237" wrote in message
...
i have a master dataset that has a column called status in Column T. In
Column N I have an invoice amount.
If the status is "cleared" then I do not want the subtotal to include the
invoice amount, thus if there is no value (blank) in column T then I want the
equivilent column N invoice amount to be included in the subtotal.

How can i accomplish this without using a filter?

subtotal worksheet based on criteria
 

perfect, thanks!

"Gary Keramidas" wrote:

if data is in n2:n13 and t2:t13

=SUMIF(T2:T13,"<cleared",N2:N13)

--


Gary


"Belinda7237" wrote in message
...
i have a master dataset that has a column called status in Column T. In
Column N I have an invoice amount.
If the status is "cleared" then I do not want the subtotal to include the
invoice amount, thus if there is no value (blank) in column T then I want the
equivilent column N invoice amount to be included in the subtotal.

How can i accomplish this without using a filter?