Hi all, I am trying to do a SUMIF so that YTD for last year matches this year.
So in this example I want the SUM of Jan/Feb 2018 vs SUM of Jan/Feb 2017 to show in my totals at the bottom.
I have a formula that works except it falls apart when I have a zero for a month that should be included (like Jan in this example)
This is what I have
=SUMIF(C14:C25,B14:B25,"<>"&""&0)
So total for 2017 is showing as 1 when it should be 7.
I've tried everything I can think of to fix it! Any help would be appreciated!
Apologies work browser settings won't allow me to copy / paste properly.
The figures for 2018 are B14:B25 and 6 for 2017 is C14:C25 if that helps.
<tbody>
</tbody>
So in this example I want the SUM of Jan/Feb 2018 vs SUM of Jan/Feb 2017 to show in my totals at the bottom.
I have a formula that works except it falls apart when I have a zero for a month that should be included (like Jan in this example)
This is what I have
=SUMIF(C14:C25,B14:B25,"<>"&""&0)
So total for 2017 is showing as 1 when it should be 7.
I've tried everything I can think of to fix it! Any help would be appreciated!
Apologies work browser settings won't allow me to copy / paste properly.
The figures for 2018 are B14:B25 and 6 for 2017 is C14:C25 if that helps.
BOOKINGS | ||
2018 | 2017 | |
JAN | 0 | 6 |
FEB | 4 | 1 |
MAR | 0 | 1 |
APR | 0 | 0 |
MAY | 0 | 3 |
JUN | 0 | 1 |
JUL | 0 | 0 |
AUG | 0 | 2 |
SEP | 0 | 0 |
OCT | 0 | 1 |
NOV | 0 | 3 |
DEC | 0 | 3 |
TOTAL | 4 | 1 |
YTD +/- |
<tbody>
</tbody>