I have the following formula: =SUMPRODUCT(--(INT((MONTH(data!$A$6:$A$530)=5)*(data!F$6:$F$530="Fall")*(data!$C$6:$C$530="0701-1100"))))
I need to have the formula sum both Fall and Successfull Fall (both are in column F). I have tried to use the wild card *, but this returns a wrong number.
Any help would be appreciated. Thanks!
Hi cpope,
I'd first try the OR operator and see if it works....
Instead of
(data!F$6:$F$530="Fall") try
(OR((data!F$6:$F$530="Fall") ,(data!F$6:$F$530="Successfull") )
If/when that didn't work I'd attach a sample of your workbook so we can work on it.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try
=SUMPRODUCT(--(INT((MONTH(data!$A$6:$A$530)=5)*((data!F$6:$F$530="Fall")+(data!F$6:$F$530="Successfull Fall"))*(data!$C$6:$C$530="0701-1100"))))
might want to spell check successfull
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks