View original (French)

Sum.if function does not contain...

Solved
Alex -  
Bruce Willix Posted messages 12376 Registration date   Status Contributeur Last intervention   -
Hello,

I need help with a formula in Excel please!

I would like to sum the numbers in my column C, but without considering the grand total and the non-responses in column B.

I managed to create the function for just one of the two criteria:
=SUMIFS(B:B,"<>Total general",C:C)
but I can't figure out how to do it for both at the same time.

How should I do it?

Thank you in advance

2 réponses

Réponse 1 / 2
Bruce Willix Posted messages 12376 Registration date   Status Contributeur Last intervention   2 638
 
You must use the SUMIFS() formula.

--
Remember remember the fifth of November
Gunpowder, treason and plot.
I see no reason why gunpowder, treason
Should ever be forgot...
2