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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 4, 2010 at 09:20 PM
Related:
- Excel Help...
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
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
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.
. 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.
