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
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!
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!
