Hi everyone,
hopefully someone may be able to help, I use office 2010 but a userbase is using 2003, I produced the following formula in 2010
=SUMIFS('Tech Requirement detail'!$G$3:$G$285,'Tech Requirement detail'!$O$3:$O$285,"Unix",'Tech Requirement detail'!$F$3:$F$285,"SBB 793")
so converted this to what I assumed was the 2003 equiv but it doesnt work
=SUMPRODUCT(('Tech Requirement detail'!$F$3:$F$285="SBB 793"),('Tech Requirement detail'!$O$3:$O$285="UNIX"),'Tech Requirement detail'!G3:G285)
any help gratefully received
Stuart
Last edited by chuckie01; 08-19-2011 at 09:54 AM. Reason: Solved
Are you entering this with <Ctrl>+<Shift>+<Enter>
rather than just <Enter>?
Perhaps
=SUMPRODUCT(('Tech Requirement detail'!$F$3:$F$285="SBB 793")*('Tech Requirement detail'!$O$3:$O$285="UNIX")*(Tech Requirement detail'!G3:G285))
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
No, just enter,
I have the SUMIF on one row and have the answer of 3 which is correct, however the SUMPRODUCT on the row below has the answer 0. exactly the same range of cells
Have you tried my suggestion ? ( the comma does not coerce the two first ranges to numeric values)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
=SUMPRODUCT(('Tech Requirement detail'!$F$3:$F$285="SBB 793")*('Tech Requirement detail'!$O$3:$O$285="UNIX")*(Tech Requirement detail'!G3:G285)) the formula errors at the bold still
=SUMPRODUCT(('Tech Requirement detail'!$F$3:$F$285="SBB 793")*('Tech Requirement detail'!$O$3:$O$285="UNIX")*('Tech Requirement detail'!G3:G285))
Missing apostroph
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Excellent, you are a star, thank you very much.
FYI there is a very complete article about SUMPRODUCT at http://www.xldynamic.com/source/xld....T.html#classic
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks