Forum Discussion
Solved
Search for date and then add cells in a column HELP
Please can I ask for a little help finishing this formula. I have two columns A & B, A is a date range and B contains data which I need to add up for a given date range. In the example I am giving I ...
- in column B - eliminate first the #N/A .
if there is formula in B, use this =IFNA(YOUR FORMULA,"")
HTH
Also found this online, but again it cannot handle the #N/A's.
=SUMIFS(amount,date,">"&H5,date,"<"&H6)
=SUMIFS(amount,date,">"&H5,date,"<"&H6)