Getting a value error while using SUMIFS function

Question

I want the gross amount of each unique email if the days remaining is less than 12 and if the unique email is present in the email column.

I have used SUMIFS function but I am getting a value error.

Is there any workaround?

EDS · Answer 1 · 2021-08-04T13:23:24.850

0

For clarity after post edit: IF(days_remaining>=value, "", SUMIF(email_range, email, gross_value_range))

edited Aug 04 '21 at 13:23

answered Aug 04 '21 at 12:10

EDS

Tried it but it doesn't help me with the expected output – Vignesh Satheesh Aug 04 '21 at 12:48
What is the expected output if the days remaining is greater than or equal to 300 (add to your question if you get a chance)? Replace the "" with that – EDS Aug 04 '21 at 12:50
I want the gross amount of each unique email if the days remaining is less than 300 and the duplicate email = unique email. – Vignesh Satheesh Aug 04 '21 at 12:58
So what is the expected output if the days remaining is greater than or equal to 300? – EDS Aug 04 '21 at 13:01
Your edit shows values greater than 12 being blank. That is what my formula does – EDS Aug 04 '21 at 13:24
the output should be like the gross amount of a@a.com = xxx amount – Vignesh Satheesh Aug 04 '21 at 13:27

1 Answers1