subtotal worksheet based on criteria

[Belinda7237]

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?

 

[Gary Keramidas]

if data is in n2:n13 and t2:t13

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

 

[Belinda7237]

perfect, thanks!

if data is in n2:n13 and t2:t13

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