New profile posts

Excel Enthusiast: Meet nbcdns!​

Data wrangling wizard by day, spreadsheet sculptor by night. nbcdns thrives in the world of Excel. They love crafting elegant formulas, automating tasks with VBA, and building beautiful dashboards that tell insightful stories.

And thank you my name is Jeff Crawford I'm glad to try to join this little thing please let me know lovetolearn more about the Carthaginians what I can do better thank you Jeff Crawford​

---

Yeah mostly checkingñ the Site out So I know if ill like it an stuff thanks again J.D.

Click to expand...

Hello,
Can I get help on this? See link https://docs.google.com/spreadsheets/d/1mXNdV2D706jqemUB6NgCeeCN3sTncJx-aVuJrUQPgOw/edit?usp=sharing

Hi Zahid

Attached file is an extract of the main file. The formula I am trying to sort is at row 405/406. Trying to get a sum of all items from the table that are in the appropriate mth and day/night per column C and row 380.

As I download rows 1-374 from a utility company I'm trying to avoid putting the day/night at the top when I could then use a pivot table to do the same thing.