ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding numbers (https://www.excelbanter.com/excel-discussion-misc-queries/189023-adding-numbers.html)

computerkiller

Adding numbers
 
Sorry the the subject was incorrect, but this is difficult for me to
descripe. I have checkmark in an column and I would like to add the
associated values in the third column. How would I do this? Example
checkmark vetbill $250
garbage $50
hydro $25
checkmark rent $750

$1000


Norman Jones[_2_]

Adding numbers
 
Hi Computerkiller,

Try Excel's SumIf formula, e,g.:


=SUMIF(A1:A100,"Checkmark",C1:C100)



---
Regards.
Norman


"computerkiller" wrote in message
...
Sorry the the subject was incorrect, but this is difficult for me to
descripe. I have checkmark in an column and I would like to add the
associated values in the third column. How would I do this? Example
checkmark vetbill $250
garbage $50
hydro $25
checkmark rent $750

$1000




All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com