Excel Help...

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am an excel beginner and looking for some help.

Here is what I am working with...


Unit $35,000
Unit $60,000
Escrow $100,000
Unit $75,000

Column A has the type (either Unit or Escrow) and Column B has the $ value. I need to automatically calculate the total $value of Escrow and total $value of Units.

The excel sheet is actually quite larger but I'm hoping this will be enough of a sample for someone to help get me started. I appreciate anyone taking the time to help me out.

Regards,

mqriaz1





1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
1. Amounts are numbers . DO NOT ENTER these as $ 100000
. but enter simply as 100000 and then if necessary format it as you like this. If you just enter as $10000 it will not take it as number but only as text and will not do the sum .

2. you always have a column headings in row no. 1, which will be a good practice.
in that case the data will be like this


hdng1 hdng2
Unit 35000
Unit 60000
Escrow 100000
Unit 75000


3. now in any empty cell type or copy this formula

=SUMPRODUCT((A2:A5="Unit")*(B2:B5))

here your last tow is 5 and os A5 and B5 in the formula. modify this to suit your last row.

countif formula can also be used but if the above formula works it should be ok for you.