How to sum a number from a range of cells, based on value
Solved/Closed
cathcam
Posts
2
Registration date
Saturday September 30, 2017
Status
Member
Last seen
October 2, 2017
-
Sep 30, 2017 at 03:28 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 5, 2017 at 11:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 5, 2017 at 11:07 AM
Related:
- How to sum a number from a range of cells, based on value
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated on Oct 2, 2017 at 12:08 PM
Updated on Oct 2, 2017 at 12:08 PM
Hi Cathcam ,
You can either change the formula you have
=SUM(IF(N2:N204="ceremony",O2:O204))
into an array formula by hitting Ctrl+Shift+Enter instead of just enter. Doing this will enclose your formula in curly brackets.
Or you can use the COUNTIF function:
=COUNTIF(N2:N204,"ceremony",O2:O204)
Best of luck with the wedding :-)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
You can either change the formula you have
=SUM(IF(N2:N204="ceremony",O2:O204))
into an array formula by hitting Ctrl+Shift+Enter instead of just enter. Doing this will enclose your formula in curly brackets.
Or you can use the COUNTIF function:
=COUNTIF(N2:N204,"ceremony",O2:O204)
Best of luck with the wedding :-)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Oct 2, 2017 at 07:26 PM
=sumif(N:N,"ceremony",O:O)
FYI, COUNTIF only take 2 arguments, so it tells me how many acceptances.
Thank you so much for getting me on the right path.
Oct 5, 2017 at 11:07 AM
Good to see you worked it out.