ISSUES with SUMIFS

[adsako]

Hello All

I got simple issue with SUMIFS function ...
I'm trying to get sum of values if values from the list do not equal to criteria

in Cell F8 I applied formula as below however it calculates as criteria are (OR) not (AND)

=SUMIFS($C$3:$C$58, $A$3:$A$58, "<>"&$G$4, $B$3:$B$58, "<>"&$G$5)

what I'm looking for is to sum values providing that both criteria are met at the same time (AND) which means sum should exclude only one cell (C58) as this cell meets criteria so i should receive value: 977,729.32
now excel gives me value 925,031.39 which is sum of all values from column B with 2020 in it (excluding 2021) and top of that value from cell C7 is deducted (=as this cell meets one of the criteria) which means at the moment excel sums values from range C3:C54 and deducts value from cell C7 and I need values from cells C3:C57 as last cell meets both criteria

Can you please advise where is the issue or what should be changed or maybe some other formula should be used?
I'm confused

thank you