How to use SUMIF to extract attendance details from a register
Category: [Excel] Demo Available
How to use SUMIF to extract attendance details from a register
Requirement:
The user has a spreadsheet with delegates attending a function whereby when the user selects Admit = Yes, excel must count the number of invitees for example 1 or 2 or 3 people and write that value in the highlighted cell in yellow and deduct from the number of people attending.
And the same time highlight the row once the delegates have been signed in.
Solution:
=SUMIF(F6:F128,"Yes",E6:E128)
Obtained from the OzGrid Help Forum.
Solution provided by pike.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use SUMIFS and include 'All' to Drop-down IndexMatch |
| How to use SUMIF |
| How to combine LARGE and SUMIF - Array formula |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.