I'm new and really only joined because I need help with this problem. I have an above-layman understanding of Excel, having taught myself by researching online, but this has stumped me for over a week and at this point I have wasted too much energy getting nowhere and need help.
I'm working on building an attendance database for a bereavement team that tracks throughout the year and sums each quarter. Excel had a template that was exactly what I was needing. I got my Pivot tables set up and I'm almost done but because the sheet that sums all sheets for an annual total returns a 0, the counts on my pivot table are counting each individual listed in the database instead of the individual non-zero cells in the column.
I've read through several posts here and elsewhere saying to use the SUMPRODUCT(SUMIF(INDIRECT( formula but every time I've seen that used, it is summing a range of data on each sheet; I need to sum 1 specific cell on 4 sheets and have a blank cell instead of a zero.
The formula I have now is =SUM('1st Q:4th Q'!C2).
Thanks for any help!
Bookmarks