Sum specific cells only not entire column

[Guest]

Can you please help! I have a very large column; I would like to sum at the
end everything that reads paid and everything that reads reversed in
different cells
Example:
1 A B
2 Status Amount
3 Paid $500.00
4 Paid $500.00
5 Reversed $400.00
6 Reversed $200.00
7 Paid $600.00
8 Reversed $700.00
9
10 Total Paid $1,100.00
11 Total Reversed $1,300.00

 

[Guest]

=sumproduct(--(a2:a100)="Paid"),(b2:b100))

=sumproduct(--(a2:a100)="Reversed"),(b2:b100))

Or use SUMIF.

HTH

 

[Ken Wright]

Use SUMIF

=SUMIF(A1:A14,"paid",B1:B14)
=SUMIF(A1:A14,"Reversed",B1:B14)

Syntax is

=SUMIF(range,criteria,sum_range)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

Thank you. It works.

Use SUMIF

=SUMIF(A1:A14,"paid",B1:B14)
=SUMIF(A1:A14,"Reversed",B1:B14)

Syntax is

=SUMIF(range,criteria,sum_range)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

I am getting a error message with this formula.

=sumproduct(--(a2:a100)="Paid"),(b2:b100))

=sumproduct(--(a2:a100)="Reversed"),(b2:b100))

Or use SUMIF.

HTH