I'm trying to find a code that I can write for Excel. My goal was to add up all the "X"s in a column and then multiply that total by \$25.

Example: If you completed a task, mark "X" in cell B3, and if you completed it again, mark "X" in cell B4. I need another cell to multiply by \$25 and add up every "X" in the column. Therefore, this specific cell would equal \$100 if 4 of the cells in column B contained a "X".
Sep 30, 2022 in Others 250 views

## 1 answer to this question.

Use countif for the count then multiply it by \$25.00

`=COUNTIF(B:B,"X")*25`
• 63,420 points

## Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

## Add some word to all or some rows in Excel?

Solution: Select All cells that want to change. Right ...READ MORE

## How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

This code will work: Imports Microsoft.Office.Interop Private Sub Button1_Click(sender ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE