Formula for adding different criteria

[hmwelch]

Hi All,

I've attached a picture of my spreadsheet. I'm trying to come up with a formula that will add the "# of Logins" column by group. For example, I want to see, in one cell, the total number of logins for the "Group 1" group, and so on and so forth. Please help!

Thanks!

-Hayley

[gmr4evr1]

Al lot of us are unable to see images (myself included) on here. Can you attach a sample of what you have and what you want??

[hmwelch]

I've attached a picture instead of putting it in the post. Can you see it now?

[gmr4evr1]

hmm....Oddly enough, I cannot.

[JeteMc]

Use this formula to get a count of Group 1 logins:

Please Login or Register  to view this content.

Let me know if you have any questions.

[hmwelch]

Thank you so much!! I actually ended up using a pivot table that did a sum of the logins per group. Thanks again!

[JeteMc]

You're Welcome and thank you for the feedback. A pivot table is a good solution, glad that it worked for you. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.