# Excel Help...

Closed
mqriaz1 - Oct 4, 2010 at 03:55 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 4, 2010 at 09:20 PM
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

Related:

## 1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 4, 2010 at 09:20 PM
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.