Forum Discussion
Solved
SUMIFS not working with blanks.
Hi, I try to write a formula: =SUMIFS(Table1[unit],Table1[ID],G17,Table1[%percen],"<99%") Hope for your response, Thank you.
If you run 2021 or 365, in H17:
=SUM((Table1[ID]=G17)*(Table1[%percen]<99%))With other versions, to avoid validating the above as an array formula (Ctrl+Shift+Enter on Windows), in I17:
=SUMPRODUCT(--(Table1[ID]=G17), --(Table1[%percen]<99%))
I have not tried myself but if you write "...,Table1[%percen]*1,..." all may be well.
You cannot do that - functions such as SUMIFS expect a range, not an expression,
