If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sumproduct formula returns #name error
Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am getting #Name returned with the formula I have. Can someone tell mewhat I did wrong?
=SUMPRODUCT(--(A2:A500=MONTH(3)),D2500) A D Date Amount 03/14/04 62.11 04/04/04 101.54 TIA Todd |
#2
|
|||
|
|||
sumproduct formula returns #name error
Hi,
try, =SUMPRODUCT(--(MONTH(A2:A500)=3),--(YEAR(A2:A500)=2004),D2500) Notice I've added the year as a criteria. This will ensure that it totals the values for the relevant year and ignore any blank cells in Column A. Hope this helps! In article , "Todd" wrote: Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am getting #Name returned with the formula I have. Can someone tell mewhat I did wrong? =SUMPRODUCT(--(A2:A500=MONTH(3)),D2500) A D Date Amount 03/14/04 62.11 04/04/04 101.54 TIA Todd |
#3
|
|||
|
|||
sumproduct formula returns #name error
Toddł wrote . . .
Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am getting #Name returned with the formula I have. Can someone tell mewhat I did wrong? =SUMPRODUCT(--(A2:A500=MONTH(3)),D2500) ... Given this formula, it's very likely you have a #NAME? error in one or more cells in either A2:A500 or D2500. What do the formulas =SUM(A2:A500) and =SUM(D2500) return? Also, I'd guess you want =SUMPRODUCT(--(MONTH(A2:A500)=3),D2500) --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
sumproduct formula returns #name error
=SUMPRODUCT(--(MONTH(A2:A500)=3),D2500)
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Todd" wrote in message ... Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am getting #Name returned with the formula I have. Can someone tell mewhat I did wrong? =SUMPRODUCT(--(A2:A500=MONTH(3)),D2500) A D Date Amount 03/14/04 62.11 04/04/04 101.54 TIA Todd |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Formula copied to new cells returns value, not formula result? | Gary: [email protected] | Worksheet Functions | 1 | November 3rd, 2003 02:06 AM |