# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to write a formula that will return the value of the Net Invoice Amount ('Invoice Data'!D) if the Account IDs (Calculations!F, 'Invoice Data'!A) and Billing Periods (Calculations!G1:V1, Invoice Data!C) match.
Solved by E. H. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 15/08/2018 - 03:29
Hello, attaching the file now
Excelchat Expert 15/08/2018 - 03:29
Hi
Excelchat Expert 15/08/2018 - 03:30
Welcome to Got it Pro
User 15/08/2018 - 03:30
I'm going to have to drop this into a Google Doc to share. The file is to large
Excelchat Expert 15/08/2018 - 03:30
ok
Excelchat Expert 15/08/2018 - 03:30
User 15/08/2018 - 03:31
User 15/08/2018 - 03:31
I'll try
Excelchat Expert 15/08/2018 - 03:31
No not like this
Excelchat Expert 15/08/2018 - 03:32
User 15/08/2018 - 03:34
It crashed when I tried to drop it in the sheet
Excelchat Expert 15/08/2018 - 03:34
Just make a small sample file and share the data
Excelchat Expert 15/08/2018 - 03:34
don't make it a huge file
Excelchat Expert 15/08/2018 - 03:35
One we figure out the soution you can incorporate in actual sheet
User 15/08/2018 - 03:35
Good idea
User 15/08/2018 - 03:36
Sorry.. keeps crashing
User 15/08/2018 - 03:38
Here
Excelchat Expert 15/08/2018 - 03:39
Yes tell now
Excelchat Expert 15/08/2018 - 03:39
What is the requirement here?
User 15/08/2018 - 03:40
I need a formula that will place the associated Invoice Amount if the Account ID and Dates match
User 15/08/2018 - 03:40
Invoice amount is on the Invoice Data sheet under column D
User 15/08/2018 - 03:41
The Date for the Invoice is C
User 15/08/2018 - 03:41
And the Account ID for the Invoice is A
Excelchat Expert 15/08/2018 - 03:41
See the formula on calculations sheet
User 15/08/2018 - 03:42
Yes, dropping it into the original now
Excelchat Expert 15/08/2018 - 03:43
That is how the formula would look like if it matches ID and month-year data
Excelchat Expert 15/08/2018 - 03:43
=SUMIFS('Invoice Data'!\$D:\$D,'Invoice Data'!\$A:\$A,\$A3,'Invoice Data'!\$C:\$C,B\$1)
User 15/08/2018 - 03:44
That should work... my only thought is, what if there were two invoices in a month? That's why I didn't go with the Sumif originally
User 15/08/2018 - 03:45
I guess it would error out if that were the case with an IF Function
User 15/08/2018 - 03:45
Correct?
Excelchat Expert 15/08/2018 - 03:46
this is the file as well....if there are two invoices in a month with same id then they will add up in the formula
User 15/08/2018 - 03:47
Cool, thank you so much!
Excelchat Expert 15/08/2018 - 03:47
Welcome
Excelchat Expert 15/08/2018 - 03:47
Please do give good rating and reviews
Excelchat Expert 15/08/2018 - 03:47
It would help a lot
Excelchat Expert 15/08/2018 - 03:47
Have a great day
User 15/08/2018 - 03:47
Of course, all 5 stars!
Excelchat Expert 15/08/2018 - 03:47
Take Care

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.