Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #99
| From | Mike Copeland <mrc2323@cox.net> |
|---|---|
| Newsgroups | comp.apps.spreadsheets |
| Subject | Excel Selections with Multiple Criteria |
| Date | 2025-01-24 16:07 -0700 |
| Organization | A noiseless patient Spider |
| Message-ID | <MPG.41fdcb03477252ad9896fd@news.eternal-september.org> (permalink) |
I have an Excel workbook that has data I need to use for calculations. I have Dates and Patient codes I wish to analyze. For example: Date Cost Patient 11/13/2024 3.50 Trazodone 50mg tablet L 12/07/2024 17.00 Benazepril 10mg M 12/17/2024 26.49 Rivastigmine 9.5mg/24hr L 12/19/2024 44.90 Liothyronine SOD 5mcg M 01/09/2025 51.09 Levetirscetam CVS M 01/13/2025 26.49 Rivastigmine 13.3mg/24hr L To summarize yearly totals for patients, I probably should use SUMIF with multiple criteria, but I can't seem to put it all together with a working Excel formula. Please advise. TIA -- This email has been checked for viruses by Avast antivirus software. www.avast.com
Back to comp.apps.spreadsheets | Previous | Next — Next in thread | Find similar
Excel Selections with Multiple Criteria Mike Copeland <mrc2323@cox.net> - 2025-01-24 16:07 -0700 Re: Excel Selections with Multiple Criteria Rocinante <rocinante@gmail.com> - 2025-02-15 16:57 -0500
csiph-web