From Mike Copeland@21:1/5 to All on Fri Jan 24 16:07:00 2025
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