Dear Paul Sir
Please accept my apologies (G10 & G11 Cell). I had made an error on my part
in accidentally.And Overall formula is perfect as per mind.And this is
sumif formula & put in subject If formula also apologies for that.
Thanks again.
Regards
Amar
On Wed, Feb 24, 2016 at 7:29 PM, Paul Sc
You keep mentioning an "IF" formula, but I don't see one.I'm not sure what
"test" you're expecting for an "if" formula.It looks like you're trying to
simply add the values in the two columns (C and D)for each of the values in
column B.
This can be done with the Sumif() function.
See attached.
al
Dear Paul Sir thanks very much for this, but if there are another (column
criteria) add in formula then how to modified IF formula?.
Pls check sheet for sample
Regrads
Amar
On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner
wrote:
> In cell G4, enter formula:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy
In cell G4, enter formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down
through column G.
The "$" means that the beginning row of the range is "anchored" which means
that the first row of each range is 4,but the ending row of each range will
increment to match the "current"
row.Paul
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
