Simple totals

[Sir Arthur]

Hi there.

I'm creating a spreadsheet that displays invoices my business has sent out.
When they are paid I add the date into a "Paid" column. While they are unpaid
the cell is left blank.

What formula would be needed to create automatic totals for paid and unpaid
invoices?

TIA

 

[Jacob Skaria]

Suppose you have column B with dates and ColA with the amount; then try the
below formulas

'Paid total
=SUMIF(B:B,">0",A:A)

'Unpaid total
=SUM(A:A)-SUMIF(B:B,">0",A:A)

 

[Ms-Exl-Learner]

I suggest you to use Sumif Function.

=SUMIF("PAID & UNPAID CELL RANGE","PAID","RANGE OF PAID & UNPAID VALUE")

Examples:-
=SUMIF(A1:A50,"PAID",B1:B50)
=SUMIF(A1:A50,"UNPAID",B1:B50)

Remember to Click Yes, if this post helps!

 

[Sir Arthur]

Thanks to both of you. All sorted.

I suggest you to use Sumif Function.

=SUMIF("PAID & UNPAID CELL RANGE","PAID","RANGE OF PAID & UNPAID VALUE")

Examples:-
=SUMIF(A1:A50,"PAID",B1:B50)
=SUMIF(A1:A50,"UNPAID",B1:B50)

Remember to Click Yes, if this post helps!

 

[Jacob Skaria]

In cell AU7 apply the below formula and copy down as required.

=IF(V7=V6,"",SUM(AT7:INDEX(AT7:$AT$100,MATCH(TRUE,INDEX(V7:$V$100<>V7,),)))-INDEX(AT7:$AT$100,MATCH(TRUE,INDEX(V7:$V$100<>V7,),)))