SUMIFS with empty cells
Solved
Zorbaxx
Posted messages
29
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello, I'm reaching out to you once again for a sum problem this time.
I need to perform sums within time ranges based on certain conditions. I was using the SUMIFS function. The issue is that some of my cells that contain my criteria are empty. Let me explain.
In my columns F and G, there are dates and times, and in column N, there are values that I need to add up. The problem is that in F and G, the times and dates are not present on all rows, so Excel only adds up the rows where the dates and times are present, and I would like all values to be summed. I hope I've been clear enough. Thank you for your help.
P.S.: I forgot to mention that, of course, the table is subject to change every day and is imported, so I cannot modify it (otherwise, it wouldn't be fun ^^). It has between 1200 and 1500 rows.
I need to perform sums within time ranges based on certain conditions. I was using the SUMIFS function. The issue is that some of my cells that contain my criteria are empty. Let me explain.
In my columns F and G, there are dates and times, and in column N, there are values that I need to add up. The problem is that in F and G, the times and dates are not present on all rows, so Excel only adds up the rows where the dates and times are present, and I would like all values to be summed. I hope I've been clear enough. Thank you for your help.
P.S.: I forgot to mention that, of course, the table is subject to change every day and is imported, so I cannot modify it (otherwise, it wouldn't be fun ^^). It has between 1200 and 1500 rows.
2 answers
-
Good evening
you do not specify exactly what the criteria for selecting the data to be summed are- for the time slots, we should be able to use the OFFSET function combined with COUNTIF and MATCH
- If we need to take into account the code in column I or (and) J, we could consider a column with a formula that will repeat the codes across all the rows, but we would need a model to work this out
could you upload it here:
http://mon-partage.fr
and come back to paste the created link on the site
add some explanations in a note in the file if necessary.
looking forward to hearing from you
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
