Sum specific cells only not entire column
 

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

Sum specific cells only not entire column
 

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

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

Or use SUMIF.

HTH

"Mary" wrote:

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

Sum specific cells only not entire column
 

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

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

Sum specific cells only not entire column
 

I am getting a error message with this formula.

"Toppers" wrote:

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

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

Or use SUMIF.

HTH

"Mary" wrote:

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