What formula to use to add values for an exact date on excel?

Copper Contributor

Hi, 

 

I would like to add the total amount spent per day for all the customers who spent money in the day. Do you know what formula to use? I only get the first result back from the first column when I use sumif function.

2 Replies
No need for SUMIF() here, just SUM(C4:F4) will do you (for the first one, then copy down).