Excel Drop Down / Formula Help
Closed
darthchester
Posts
2
Registration date
Tuesday October 16, 2012
Status
Member
Last seen
October 17, 2012
-
Oct 16, 2012 at 03:32 AM
darthchester Posts 2 Registration date Tuesday October 16, 2012 Status Member Last seen October 17, 2012 - Oct 17, 2012 at 04:20 AM
darthchester Posts 2 Registration date Tuesday October 16, 2012 Status Member Last seen October 17, 2012 - Oct 17, 2012 at 04:20 AM
Related:
- Excel Drop Down / Formula Help
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Oct 16, 2012 at 06:45 AM
Oct 16, 2012 at 06:45 AM
Hi darthchester,
You can use SUMIFS() worksheet function to accomplish this task. Fill column E with the list of your categories (viz., E2 - Category 01, E3 - Category 02... E12 - Category 11). Put the following formula in F2 and drag till F12:
=SUMIFS($C$1:$C$1048575,$D$1:$D$1048575,E2)
You will get the desired result (i.e., sum of values in column C against the categories in column D). No need to do any VBA programming.
Please reply if you have any further questions.
You can use SUMIFS() worksheet function to accomplish this task. Fill column E with the list of your categories (viz., E2 - Category 01, E3 - Category 02... E12 - Category 11). Put the following formula in F2 and drag till F12:
=SUMIFS($C$1:$C$1048575,$D$1:$D$1048575,E2)
You will get the desired result (i.e., sum of values in column C against the categories in column D). No need to do any VBA programming.
Please reply if you have any further questions.
Oct 17, 2012 at 04:20 AM
Thank you so much, kind friend. This is in fact the exact thing I was looking for. My spreadsheet is complete and working wonderfully!
Thanks again.
DC