Excel - add all X in column and then multiply

0 votes
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 in Others by Kithuzzz
• 20,660 points
45 views

1 answer to this question.

0 votes

Use countif for the count then multiply it by $25.00

=COUNTIF(B:B,"X")*25
answered Oct 1 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Add some word to all or some rows in Excel?

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

answered Nov 11 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

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

answered Nov 17 in Others by narikkadan
• 37,660 points
29 views
0 votes
2 answers
0 votes
1 answer

All in one seo pack and qtranslate title attributes

try changing one of the plugins and ...READ MORE

answered Feb 17 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

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

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
450 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

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

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
395 views
0 votes
1 answer

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

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

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,367 views
0 votes
1 answer

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

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,830 views
0 votes
1 answer

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

answered Nov 4 in Others by narikkadan
• 37,660 points
34 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
34 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP