Sum specific cells only not entire column

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
=sumproduct(--(a2:a100)="Paid"),(b2:b100))

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

Or use SUMIF.

HTH
 
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 :-)
------------------------------­------------------------------­----------------
 
Thank you. It works.

Ken Wright said:
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 :-)
------------------------------­------------------------------­----------------
Click to expand...
 
I am getting a error message with this formula.

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

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

Or use SUMIF.

HTH
Click to expand...
 
Back
Top