Sum specific cells only not entire column
Thank you. It works.
"Ken Wright" wrote:
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 :-)
------------------------------Â*------------------------------Â*----------------
"Mary" wrote in message
...
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
|